Getting data from outlook and excecuting excel vba
Posted by John on January 09, 2002 3:35 AM
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 a macro in excel that will strip it and reformat the information. I know how to write the code to stip the information once excel is started but I don't know how or if I can auto execute this from MS Outlook. Is this possible and if so do you have any advice or ideas on how to do this.
Any help would be appreciated,