View Single Post
  #2   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

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