Outlook message in Excel

[Andre Croteau]

Hello,

In OUTLOOK 2000, I receive many emails that have messages set in the same
structure.

I am able to copy and paste the message in my Excel spreadsheet, and then
manipulate the data.

The problem is I have about 100 emails/day to look at, and I would love to
have to process automated

Say I have all my emails in a directory Personal\Inbox\data
I would like to copy /paste all the messages into ONE Excel sheet, all one
after the other in column A.

Can this be done?

Many thanks in advance

André

 

[Ron de Bruin]

Hi Andre

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

 

[Andre Croteau]

Hello Ron,

Thank you very much for the link. I am leaning so much!!

I was able to extract the body of the message to my Excel spreadsheet.
However, the whole body of the message is now in one HUGE cell in my
spreadsheet. I was hoping that the 15 lines of the message body would be
copied on 15 different rows on the spreadsheet. I have sent a message to
the site's author asking for guidance to see if it is possible to do.

Would you happen to know how?

I also must say that your own site "Example Code for sending mail from
Excel" has helped me greatly to make things more efficent.

warm regards

André

 

[Ron de Bruin]

Hi Andre

Sorry I can't help you (I only save attachments myself from mails)
I am sure Dick can help you.