Export Outlook body to excel

Microsoft Outlook 2010 software
August 20, 2010 at 11:53:17
Specs: Windows XP
I am trying to export the body of text email that customers fill out for a form on the web. It comes in the form of:
In-Home Energy Audit Request From:

John Customer
11 Coolidge Place
Durham NC 27705

(919) 999-9999

Best Time for an Appointment: Morning

Approximate Square Footage of Home: 3000

Year Home was Built: 1999

Type of Home: Siding

Type of Foundation: crawl space

Type of Fireplace: Natural Gas

I have the following natural gas appliances in my home:

Water Heater
I would like to export each piece of data after the colon to an excel column. I used VBA but it puts all my data in one column for the body.

See More: Export Outlook body to excel

March 20, 2011 at 21:31:20

I have exactly the same requirement as you -- same problem with web form data when I extract to Excel. Please let me know if you have found a solution. Thanks

Report •
Related Solutions

Ask Question