Questions

How do I get an Outlook Macro to sort emails into a specific hierarchy?

Tags: Windows, Software, Community
+
0 Votes

How do I get an Outlook Macro to sort emails into a specific hierarchy?

vorlag
I have been reading guides for weeks on how to do this and I've tried a few different things, but nothing has been working. I'm either missing a key step here or something, I don't know.

What I need and am trying to do is get Outlook to sort my emails by project, month, and name of sender. I get a bazillion emails a day and if I don't sort them, my inbox fills up (because it's way too small, thanks cheapskate employer, haha). If I am away for 2 days, I will come back to a full inbox and won't have received some emails because of it. I'm not sure if there's a way to set a macro or some rules to NOT be client-based rules, but that would also be very helpful.

These are the articles I was using to try to develop a macro myself:
http://www.jpsoftwaretech.com/automatically-triage-emails-by-sender-name/
http://www.jpsoftwaretech.com/look-for-and-create-folders-programmatically-in-outlook/
http://answers.microsoft.com/en-us/office/forum/office_2007-customize/outlook-vba-to-move-a-message-to-a-folder-based-on/d0b1f6d5-c958-47ea-b3a9-c5fb387b63d7?msgId=8658c0d2-3ce6-45bb-812a-0b21302e41cd

I can't get anything to work. I need for the macro to be able to create new folders with the sender's name if the email belongs in a certain project & month and the creating folders part, I HAVE been able to get to work, but it's not much help without the other pieces.

I would like to be able to designate what domains or specific email addresses are what sort of people (management,project team, consultants, and "other" being everyone I haven't identified yet for that project). I'd like to have the macro look at the domain of the sender's email first to see what company it's from, then at the date that it was received, then at the name of the person or full email address to figure their role, then the name of the sender (even if I have to define names for each email in the macro) to create a new folder for that person.

I know it's possible and that other people have done it but I don't know HOW they did it.

So, this is the format that I would LIKE to have emails go into:
<a href="http://pho.to/3N6XR" target="_blank"><img src="http://i.share.pho.to/e290081a_c.png"/></a>

ANY help would be much appreciated!!!

Member Answers