Help Copying from Outlook to Excel
 

I can get the subject, attachment info and date from an email in outlook
to be copied to excel, but does anyone know a way to get lines from the
actual message. Is there some property of the Folder.Items that gets
me this? My problem is that I have a huge set of emails whose messages
look something like this:

Name: John Smith
Telephone: 555-555-5555

and I need to write a macro to automatically copy these to a database.
Any advice will be appreciated. Thank you.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Help Copying from Outlook to Excel
 

PM8

The .Body property contains all the text that is in the body. You will then
need to parse out the strings you want. If the email is HTML, then the
HTMLBody property will contain the HTML.

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

"pearlmaster8" wrote in message
...
I can get the subject, attachment info and date from an email in outlook
to be copied to excel, but does anyone know a way to get lines from the
actual message. Is there some property of the Folder.Items that gets
me this? My problem is that I have a huge set of emails whose messages
look something like this:

Name: John Smith
Telephone: 555-555-5555

and I need to write a macro to automatically copy these to a database.
Any advice will be appreciated. Thank you.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/