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
customer@hotmail.comBest 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
Furnace
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.
Hello, 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