Outlook 2007 Email Categorization using VBA


New Member
Outlook version
Outlook 2007
Email Account
Exchange Server 2007
Hi All,

I am new here and looking for some support with VBA for outlook.

Now i'm faced with a similar task of getting something done with outlook and I was hoping someone can help me out.

Here is my situation:

I have a team of 15 people that is split into 4 member groups and they all handle different types of email requests. We have one generic mailbox and all the emails flow into it. My job is to check each email for certain keywords (either in the subject or body of the email) and then assign it to a user which will also be the name of the category. Right now if I mark an email to let say category "Linda" she will take up the mail and action it.

I want to be able to distribute email categorization in an optimal format. For example, I dont want to send all type A emails to Linda, but distribute evenly to the four members in that groups and similarly for the other groups in my team. Right now this takes a lot of time and effort as the volume of emails coming in has increased.

Any help that you guys can offer will be amazing. Thanks.

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange