Outlook message in Excel
 

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é

Hi Andre

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Andre Croteau" wrote in message ...
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é

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" wrote in message
...
Hi Andre

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Andre Croteau" wrote in message
...
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é

Hi Andre

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Andre Croteau" wrote in message ...
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" wrote in message
...
Hi Andre

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Andre Croteau" wrote in message
...
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é

Users are sure to find in unable to read mail outlook express and outlook express repairs tool, simple yet versatile, to solve potential problems and stay in control of damaged dbx files in the safe folder.