From: Amon Speck on
Export outlook body data to excel


I have been looking for a macro which will extract data from the currently highlighted email in outlook and append it to a specified worksheet in an Excel workbook.

If the incoming body contains

Name: Joe Bloggs
Age:32

then the macro should send the data to the next empty row in the sheet.

Does anyone know how I can do this or provide a link with some examples to work from.

tia .
Submitted using http://www.outlookforums.com