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
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).
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks