Outlook script to forward emails based on senders' address

[Natalie]

Hello,

I desperately need help for this. My office inbox receives 100-200 emails daily which we have to disseminate to different groups of people in the firm. I was hoping to semi-automate this process by forwarding each incoming email based on the senders' address to the corresponding group of recipients. For example, if the senders' address contains "@oaktree.com", then this email should be forwarded to a group of people handling the Oaktree account.

Typically, if we only had a few accounts, I can upload each account one by one. However, we have 1000+ accounts to be forwarded and I cannot possibly upload them account by account. Each senders' address is also accompanied by a group of recipients and these are all recorded in an excel sheet.

Is there anyway for the script to search the senders' address in the incoming email, and then forward it to the relevant account handlers stated in the excel sheet?

Thanks so much so much in advance.

Best regards,
Natalie

 

[oliv-]

Same as
Outlook script to forward emails based on senders' address

 

[Diane Poremsky]

I have some macros that are close - Use a Macro to Assign Messages in a Shared Mailbox - this one shows how to assign messages to a group of people equally, round robin style.

The macro at Sort messages by Sender domain shows one way to get the domain. What my macros don't do is lookup values in a spreadsheet.