Help Copying from Outlook to Excel

  • Thread starter Thread starter pearlmaster8
  • Start date Start date
P

pearlmaster8

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.
 
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.
 
Back
Top