Saving mails in respective folders

**ramserp** · 03-17-2010, 03:49 AM

Hi Friends,

I am newbie for VBA Outlook. I worked only on Excel VBA .

The following is my question.

In my Inbox, i will be getting the mails in such a way that, where i will have some unique number in the subject line". Please find the samples here.

"101011 - User Creation"
"Re:101011 - User Creation"
"Fwd:Re:101011 - User Creation"

"102022 - User Creation"
"Re:102022 - User Creation"
"Fwd:Re:102022 - User Creation"

Based on this number, a folder should be created automatically, all the respectives mails should move there.

Example:

Create a folder called ‘My Emails’.
My Emails - Main Folder
101011 - Sub Folder
(all the three mails)
102022 - Sub Folder
(all the three mails)

Have to Extract all the email messages tied to the number & Place in folder.

If attachment exists, Ensure attachment remains attached to message Make a copy of the attachment – same name
Place in the same folder

Please kindly help me with appropriate code.

Please find the attachment for clear clarification on how mails move to folders.

Thanks & Regards
Ramesh

**teylyn** · 03-17-2010, 04:33 AM

Hi Ramserp,

why not use Outlook's native functionality with rules to put emails with a certain text in the subject into their own folder? Setting up a few rules might be way easier than creating a macro.

Set up the rule for the first number, then just copy the rule for the next number(s).

**ramserp** · 03-17-2010, 04:56 AM

Hi teylyn,

The needs to be store in folders in Hard Disk (C or D drive). Approximately there will be 1100 folders needs to create. I think setting rules for 1100 mails will be difficult task. Please help me with some code.

Thanks & Regards
Ramesh