Macro For folder Creation In Outlook 2007

Dear All,
I need help with the following ..I want to have a Macro which can creat folders in outlook 2007 using the List in Excel 2007 as a master sheet..Attached is the worksheet detailing the request ..I have not worked on this as I am not sure about the possibility so there are no macros in the attached sheet ..
N

Hi Nutty

Try the code in the attached. It works for me. If you want colors, you'll need to have someone else involved. I'm colorblind.

All code from
http://www.codeforexcelandoutlook.co...ly-in-outlook/

I forgot to mention that you'll need to set a reference to Microsoft Outlook Object Library.

Hi Nutty

I'd like you to take the time to review your needs. I'm spending considerable time working FOR you and your needs change like I change skivvies (look it up). Much of your current requirements as indicated on your most recent file are not included in earlier Threads. Now, I know needs change...however...you need to define the project. Else, you'll drive us all "Nutty".

Get back to me and let me know IF your latest post IS what you need. Is there ANYTHING else?

Hi Nutty

Perhaps

Onething is sure about you now is ...that you are not a cross dresser

Depending on what dictionary you used when you looked it up, that could be assumed. The broad definition is "undergarments" and most women I've known also wear "undergarments" so, I wouldn't rule out "cross dressing" as a sport.

However, that's not relevant to the issue (whether I do or don't). The relevant issue is you need to know what you wish to do so I know what you wish to do.

Hi Nutty
The code in the attached will create a new folder in Personal Folders called "Archived Mail". Within that folder, it'll create Sub Folders for any items that exist in Column D of the attached worksheet. Based on your sample file, you'll see this in Outlook Folders.jpg.

To retrieve Emails into these folders, you'll need to set up RULES in Outlook (Tools -> Rules and Alerts -> New Rule -> Move Message with specific words... -> Move to specified folder _> etc.

Were I you, I would NOT get too specific on the Word...I'd use "Red", "Green", etc. It's been tested and, believe it or not, works (sort of surprised myself).