When a certain user gets some emails he selects them and hits Ctrl+C then goes to an Excel Sheet and pastes that information. When doing this he gets From, Subject, Received, Size and Categories.
This emails are then assigned to several people and my Excel sheet already does the assigning and all.
Now what I need is a way for Excel to find that email in either one of two sub folders in outlook named "East" and "West" and then forward it to whoever it was assigned to.
I've looked all over the internet but I cannot find anything similar to my issue.
Once the email has been located I think I can have VBA send it but so far I have not been able to locate emails.
This emails are then assigned to several people and my Excel sheet already does the assigning and all.
Now what I need is a way for Excel to find that email in either one of two sub folders in outlook named "East" and "West" and then forward it to whoever it was assigned to.
I've looked all over the internet but I cannot find anything similar to my issue.
Once the email has been located I think I can have VBA send it but so far I have not been able to locate emails.