Export Outlook body to excel

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.com 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 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.

• › can you export outlook tasks to excel
• › How to export specific emails to excel?
• › Outlook 2007 to Excel
• › how to convert microsoft outlook pst to outlo
• › Export Outlook folder contents with to and fr
• › Export to Excel, formula instead of value
• › copy emai datal to excel vlook