I have a series of outlook rules in Outlook 2013 that funnel emails to appropriate folders upon receipt.
I manage a number of small projects (15-20) at a time and each one is active for 1 to 2 months.
I create a folder for each project with a 5 digit job number in the folder name.
Each email has the 5 digit job number in the subject.
Right now I create a new rule for each project which is a bit takes more effort than I would like to manage.
I would like to create a "generic" rule that searches the email for a job number that matches one of the folders and if a match is found moves a copy to that folder.
Alternately, I keep a running job list in a spreadsheet that has the job# and description (which matches the folder name) and if possible, the rule could search through the spreadsheet, find the job# in one column and find the folder name in the next column and then move the email to the right folder.
I'm not asking for the full code - some pointers on how to get started would be appreciated.