VBA Rule to move Incoming Emails based on Specific Words in Senders'Addresses to Corresponding Folde

  • Thread starter MikeJames
  • Start date Views 2,699
Status
Not open for further replies.
M

MikeJames

#1
I am using MS Outlook 2003 for personal use. Under Personal Folders,

I have created sub-folders such as Shopping\Electronics\Best Buy,

Hobbies\Art\Michaels, Auto\Alamo etc. Now I know I can create 3

different rules to find specific words "Best Buy", "Michaels", "Alamo"

on the senders' addresses and assigned them to their folders. Since I

have 30+ sub-folder categories, this will be cumbersome as it means I

have to create 30+ rules for each of them, so I thought this could be

done through a script or VBA. The VBA should check an incoming email,

look words before @ on sender's address (in my example below would be

Best Buy, Michaels, Alamo etc), check if there is a sub-folder that

matches these words (Best Buy, Michaels, Alamo etc) under the Personal

Folders. If there is, move the email to that folder. Otherwise, do

nothing (leave it in the default inbox folder). Can this be done

through VBA? Please help.
 
#2
Re: VBA Rule to move Incoming Emails based on Specific Words in Senders' Addresses to Corresponding Folders

thought of posting to the outlook vba group?

"MikeJames" <yokie.cahyadi@gmail.com> wrote in message

news:63153c3e-1098-49bb-b0f7-2f41b6068508@h28g2000yqd.googlegroups.com...
> I am using MS Outlook 2003 for personal use. Under Personal Folders,
> I have created sub-folders such as Shopping\Electronics\Best Buy,
> Hobbies\Art\Michaels, Auto\Alamo etc. Now I know I can create 3
> different rules to find specific words "Best Buy", "Michaels", "Alamo"
> on the senders' addresses and assigned them to their folders. Since I
> have 30+ sub-folder categories, this will be cumbersome as it means I
> have to create 30+ rules for each of them, so I thought this could be
> done through a script or VBA. The VBA should check an incoming email,
> look words before @ on sender's address (in my example below would be
> Best Buy, Michaels, Alamo etc), check if there is a sub-folder that
> matches these words (Best Buy, Michaels, Alamo etc) under the Personal
> Folders. If there is, move the email to that folder. Otherwise, do
> nothing (leave it in the default inbox folder). Can this be done
> through VBA? Please help.
 
Status
Not open for further replies.
Top