Export outlook data

  • Thread starter Amon Speck
  • Start date Views 637
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 .

 
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.

---
"Amon Speck" <elfeste2001[at]yahoo[dot]co[dot]uk> wrote in message
news:OuTL$KP1KHA.5536@TK2MSFTNGP04.phx.gbl...
> 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 .


 

Similar threads

Top