Hi,

I wrote a VBA Script to categorize emails into state categories when they contain certain strings. Specifically, the goal is the following:

If there is a state abbreviation, in upper case, as a whole word, in subject or body, categorize that message as the state
If there is a state name, case insensitive, a whole word or part of another word, in subject or body, categorize that message as the state
Messages can be categorized as multiple states

It works, but I wanted to share the code and ask for feedback on how to improve performance, since it is really my first VBA Script, and it is doing a lot of comparisons per email.

Thanks!

Please Login or Register  to view this content.