Log in

View Full Version : File, Categorize, Log and create Task with Selected E-Mails



quirkycanuck
12-29-2015, 04:36 AM
I am trying to create a macro that will help me keep track of correspondence for particular projects in an Excel File. I want to have Outlook do the following with the currently selected message/messages

- Categorize the message (let me choose the category)
- File the message in a particular folder
- Launch an Excel file and add a line on a specific worksheet

I am very proficient with Excel VBA but I have very limited experience with Outlook and Outlook objects. If someone can help me with the general structure, I can probably fill in the details.

Any assistance appreciated. Thanks
QC

gmayor
12-29-2015, 05:52 AM
- File the message in a particular folder
Is that an Excel folder or a Windows folder?