Search Outlook mails for keyword in body and move mail to folder or create folder and move

[ANDREAAS]

Hallo everyone.

I am looking to sort mails more efficiently. I have a list of about 1000 cities and want mails to be sorted into folders based on the city names being found in the body of a mail.

i.e. When a mail is received and has the city name Cape Town for instance, if the name Cape Town is in my list off 1000 cities, that mail needs to move to a folder called "Cape Town". If the folder does not exist yet, it must create a folder.

The list of 1000 cities must be able to expand if necessary.

Thanks in advance for any assistance.

[macropod]

A forum search would turn up some code to get you started. See, for example: https://www.excelforum.com/outlook-p...subfolder.html

[ANDREAAS]

thank you. i am obviously not searching correctly as i did not find anything. will check out the link that you shared. much appreciated.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[ANDREAAS]

A forum search would turn up some code to get you started. See, for example: https://www.excelforum.com/outlook-p...subfolder.html

Hi, no sorry. Not finding anything even remotely close to what i am asking....

[ANDREAAS]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Hi, no. It does not address the question nor can i find anything close to my question in the archives.

[AliGW]

Fair enough!

[ANDREAAS]

Hi

I found this code that will work for a single criteria, but do not know how to adapt it for multiple criteria like 1000 or more different criteria.

Please Login or Register  to view this content.

[ANDREAAS]

Would it be possible to modify this code in such a way that it solves my original question?

[ANDREAAS]

bump, no reply

[ANDREAAS]

bump no reply