Export outlook data

A

Amon Speck

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
 
R

Roady [MVP]

You can do this via VBA and use rules to trigger the macro when certain
conditions are met.
A good place to get started is;
http://www.outlookcode.com

To process the data in Excel, you'll have to use Excel specific VBA but this
can be initiated from Outlook when you import the Excel library.

You can ask in the outlook.program_vba newsgroup if you need help with a
specific issue with you code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export info to another computer 2
Exporting from Outlook Express (2 identities) to Outlook 1
Export Outlook Body 3
Export Outlook Contacts to Excel 2
Outlook - Excel Macros 4
Extract specific information from the body of outlook mail to an Excel File using VBA 0
export calendar to excel 1
Customising Views in Outlook 2003 SP2 2

Top