View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_3_] Dick Kusleika[_3_] is offline
external usenet poster
 
Posts: 599
Default import mail messages in excel

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.

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

"Arnie" wrote in message
.nl...
Additional question:

How can I set the focus back on Excel?


"Arnie" schreef in bericht
.nl...
Supadoopa!

Thanks.

"Dick Kusleika" schreef in

bericht
...
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" wrote in message
.nl...
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