extract data from email into excel workbook

  • Thread starter Thread starter ­}­}¥J
  • Start date Start date
­

­}­}¥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
 
Hi Ron,

Problem arise in the first line:

Dim olApp As Outlook.Application

don't know why?

ims
 
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
 
Excel 2002 (10.2614.2625)



Ron de Bruin said:
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
Click to expand...
 
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
 
What do you mean

Can't you find it in the References list?
Do you use Outlook or Outlook Express?
 
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.
 
Back
Top