extract data from email into excel workbook

[­}­}¥J]

Dear all,

I have got tens of email with data in text format in my outlook inbox.
I want to collect these data and manipulate by Excel.
I wonder if there is any trick to read these data automatically, instead of
opening them one by one, then manually copy and paste into my excel
worksheet.

thanks!


ims

 

[Ron de Bruin]

Hi ims

Look here
http://www.dicks-clicks.com/excel/olRetrieving.htm

 

[­}­}¥J]

Hi Ron,

Problem arise in the first line:

Dim olApp As Outlook.Application

don't know why?

ims

 

[Ron de Bruin]

You must set a reference to Outlook

1) Go to the VBA editor, Alt -F11
2) Tools>References in the Menu bar
3) Place a Checkmark before Microsoft Outlook ? Object Library
? is the Excel version number

 

[­}­}¥J]

Excel 2002 (10.2614.2625)

You must set a reference to Outlook

1) Go to the VBA editor, Alt -F11
2) Tools>References in the Menu bar
3) Place a Checkmark before Microsoft Outlook ? Object Library
? is the Excel version number

 

[­}­}¥J]

There is already a tick before "Microsoft Office 10.0 Object Library"

 

[Ron de Bruin]

You must do this in the VBA editor in Excel.
In the file where you copy the macro from Dick in


You must set a reference to Outlook

1) Go to the VBA editor, Alt -F11
2) Tools>References in the Menu bar
3) Place a Checkmark before Microsoft Outlook ? Object Library
? is the Excel version number

 

[Ron de Bruin]

3) Place a Checkmark before Microsoft Outlook ? Object Library

Outlook

 

[­}­}¥J]

No this item in the list.....?

3) Place a Checkmark before Microsoft Outlook ? Object Library

Outlook

 

[Ron de Bruin]

What do you mean

Can't you find it in the References list?
Do you use Outlook or Outlook Express?

 

[­}­}¥J]

Outlook express, but i can't find Microsoft Outlook nor Microsoft Outlook in
the list.
As the list is in alphabetical order, it shoudn't be missed.

 

[Ron de Bruin]

You say Outlook

I have got tens of email with data in text format in my outlook inbox.

Outlook express

You can't use Dick's code then

Look at this program if you really want it
http://www.oehelp.com/DBXtend/Default.aspx