I have multiple emails and I would like to automatically extract information from a table included in the body of the emails. The sample email is attached. I would like to use a Macro so that I can extract the following from the table in the body of the email:
For example, Excel column headings would be:
System Affiliation (Owner or AC)
Owner Email Address
Corrected Owner Email (if needed)
Administrative Contact (AC) Name
Corrected AC Name (if needed)
AC Email Address
Corrected AC Email Address (if needed)
Emergency Contact (EC) Name
Corrected EC Name (if needed)
EC Email Address
Corrected EC Email Address (if needed)
If information in the table are blank, information should be extracted blank.
I have outlook and Excel 2010.