import mail messages in excel

Arnie · Jan 14, 2004

Hi there,

I want to import mailmessages from Outlook (or *.txt files from a directory)
into excel and make from every message a database record. Is this possible?
Every message has the same size and lines, when I try tot do this every line
goes on a new row therefore I should transpose it or somehow (but don't know
how :-(.

Thanx for every hint

Dick Kusleika · Jan 16, 2004

Arnie

You can access those messages using the code found here

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

Then you just need to parse the Body property into its components.

Arnie · Jan 16, 2004

Supadoopa!

Thanks.

Dick Kusleika said:
Arnie

You can access those messages using the code found here

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

Then you just need to parse the Body property into its components.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

Arnie · Jan 16, 2004

Additional question:

How can I set the focus back on Excel?

Dick Kusleika · Jan 17, 2004

Arnie

I don't know what you're doing, but in general the focus should never leave
Excel. You might post the code you are using. You also might look in help
at AppActivate and see if that does what you want.