In order to speed up my workflow, I want an Outlook macro that does 2 things:
1. After sending a message (to someone in my list of contacts) move the message from the "Sent Items" folder into a different folder. The folder's name is the same as the string in the contact's "File As" field.
I don't want to create Rules for each contact because many of my correspondents have multiple addressses and/or different "From" names, that I just Reply to. I assume the macro will have to search for a match on email address in order to identify the recipient (?) - this isn't a problem as I have separated my contacts into categories and there are only 100 or so contacts in the category of interest.
2. After sending a message and on receipt of a message (to/from one of my contacts) copy the "Sent" date from the message into a custom field on the General tab of that contact's form.
This is so I can keep track of the dates I last communicated with my correspondents from the Contacts view, without having to delve into each one's folder. Although I would like a hyperlink to their folder.
I have developed a lot in VBA for Excel, but am a complete newcomer to Outlook's innards. It looks pretty straightforward in the help pages but I would appreciate a few tips in order to get started. Like for example, is what I want to do possible?
cheers
Vince.
1. After sending a message (to someone in my list of contacts) move the message from the "Sent Items" folder into a different folder. The folder's name is the same as the string in the contact's "File As" field.
I don't want to create Rules for each contact because many of my correspondents have multiple addressses and/or different "From" names, that I just Reply to. I assume the macro will have to search for a match on email address in order to identify the recipient (?) - this isn't a problem as I have separated my contacts into categories and there are only 100 or so contacts in the category of interest.
2. After sending a message and on receipt of a message (to/from one of my contacts) copy the "Sent" date from the message into a custom field on the General tab of that contact's form.
This is so I can keep track of the dates I last communicated with my correspondents from the Contacts view, without having to delve into each one's folder. Although I would like a hyperlink to their folder.
I have developed a lot in VBA for Excel, but am a complete newcomer to Outlook's innards. It looks pretty straightforward in the help pages but I would appreciate a few tips in order to get started. Like for example, is what I want to do possible?
cheers
Vince.
