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