Creating and Managing Outlook Rules with Excel Table qty 300+

[SpillerBD]

Looking for a little input and suggestions before getting started, or if someone already has this, great!

I receive emails that reference specific locations in the Subject line. These need to forwarded to certain people based on that location name. No problem except for the quantity.
I plan to maintain that forwarding list with Excel.

So any VBA code snippets for creating rules in Outlook?

TIA.

 

[Rijnsent]

Hi Spiller,
DuckDuckGo helps, try e.g. this code:
https://answers.microsoft.com/en-us...-outlook/a9f45405-2305-4acf-a5e2-b249cf4070d1
http://www.gregthatcher.com/Scripts/VBA/Outlook/GetListOfRules.aspx
Cheers,
Koen

 

[SpillerBD]

Promising. The MicroSoft thread appears to have enough info to help me create the rules I need.
The GregThatcher should help report/audit rules to keep things running as desired.

Thanks.