Need a macro to extract email data to excel

**GlennO** · 07-04-2011, 02:02 AM

Hi all
I need a macro that extracts details from the body of an email, into an excel spreadsheet.
Thanks in advance. Certain details from an email need to be pulled through to a spreadsheet from the body. Each line of data from the email needs to be pulled through into a new column of the spread sheet.

Thanks

**maczaq** · 07-04-2011, 04:41 AM

Hi,

I have folowing idea:
1. save your e-mail into html or txt file
2. import whole file into excel
3. attach XLS file here

Then we will help you to filter e-mails

Best Regards
MaczaQ

**snb** · 07-04-2011, 05:02 AM

To write the bodytext of all emails in PostIn into column D:

sub snb()
  for each it in CreateObject("Outlook.Application").GetNamespace("MAPI").GetDefaultFolder(6).Items
     c01 = c01 & "|" & it.body
   Next
   sn=split(mid(c01,2),"|")

   cells(1,4).resize(ubound(sn))=application.transpose(sq)
End Sub

Thread: Need a macro to extract email data to excel

Thread Tools

Display

Need a macro to extract email data to excel

Re: Need a macro to extract email data to excel

Re: Need a macro to extract email data to excel

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions