How to parse email body from outlook to excel
Posted on 2011-03-23
I am very new to VBA and would like to know the code for parsing or extracting the following data from an email in Outlook. All I need is the Name, Address, CSZ and phone number, email address.
Is there way to do this and import into excel? This also needs to have the lines breaks removed.
Any help you can provide is greatly appreciated. Lisa
Here is an example of the data I need extracted:
Message Body below:
Hi there! I am keeping my fingers crossed! : ) Thanks so much!
Fortuna CA 95540
(123)456-7891 - Cell phone number. : )
(123)456-7891 - Home
END OF MESSAGE