Use VBA / macro to modify a rule in Outlook ?
Hi. I am a developer, but not familiar with the Outlook 2013 Object Model.
I have a client that has a small task -- In Outlook, he would like to be able to select an email message in his Inbox, and then click a button to append the sender's address to an existing "move to" rule.
He has a "customers.pst" file; In that PST file, there is a "New Mail" folder.
In Outlook, he already has a rule defined that moves new emails from a list of senders (by email address) from his default Inbox to the "Customers\New Mail" folder (when new email is received.) It takes many steps to manually add a new customer address to that rule.
I assume this would be a simple VBA macro, wherein I would get the "sender" from a selected message, then add it to the existing rule using a call to "Outlook.Rule.Conditions.F
I did find this article: Create a Rule to Move Specific E-mails to a Folder but have not been successful in modifying the sample code to meet my needs -- I've made a few attempts, but have not been able to point to the proper PST\Folder or successfully modify the "conditions".
It seems like it would not take much code, so does anyone have any examples?
-- Thanks
I have a client that has a small task -- In Outlook, he would like to be able to select an email message in his Inbox, and then click a button to append the sender's address to an existing "move to" rule.
He has a "customers.pst" file; In that PST file, there is a "New Mail" folder.
In Outlook, he already has a rule defined that moves new emails from a list of senders (by email address) from his default Inbox to the "Customers\New Mail" folder (when new email is received.) It takes many steps to manually add a new customer address to that rule.
I assume this would be a simple VBA macro, wherein I would get the "sender" from a selected message, then add it to the existing rule using a call to "Outlook.Rule.Conditions.F
I did find this article: Create a Rule to Move Specific E-mails to a Folder but have not been successful in modifying the sample code to meet my needs -- I've made a few attempts, but have not been able to point to the proper PST\Folder or successfully modify the "conditions".
It seems like it would not take much code, so does anyone have any examples?
-- Thanks
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
rgonzo1971 --
Yes, that is a good example, and similar to the one in my link. My problem is that they "create" a new rule:
-- thanks
Yes, that is a good example, and similar to the one in my link. My problem is that they "create" a new rule:
'Create the rule by adding a Receive Rule to Rules collection
Set oRule = colRules.Create("Dan's rule", olRuleReceive)
I need to figure out how to iterate through existing rules to find the existing rule "Move To Customers"Set oRule = colRules.Create("Dan's rule", olRuleReceive)
-- thanks
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Outlook
Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.
105K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
It I were setting this up I would keep it simple. I would create a rule that uses "Sender in specified address book"
Create a separate "customer" address book for all customers that need to be moved to the "Customers\New Mail" folder.
To update the rule all you have to do is add someone to the "customer" address book.