MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Outlook and VBA Excel


Posted by John on January 07, 2002 11:33 AM

Is it possible to set a mail rule in MS outlook that will launch vba excel code that will parse import the text of the email, parse it and append to an existing file in excel? If so how would I activate this? I realize that the question is quite vague but I have no idea what I can execute from outside of excel.

Thanks,

John


Posted by Dank on January 07, 2002 11:58 AM

Anything you can do with Excel VBA can be done from within Outlook. They both support automation and can completely control each other. If you provide some more detail I will be able to give you some code to start you off,

Regards,
Dan.

Posted by John on January 07, 2002 12:48 PM

Dan,

I would like to take an email that contains "lead" in the subject line when it comes in and save the text in a temporary text file and start excel. Once excel is started I can write the code to parse the text and append the specified data to a master file. Any kind of start would be of great help.

Thanks,

John