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.

• › [Solved] export contacts to excel on mac
• › [Solved] Convert Word form to Excel form
• › [Solved] Add default signature to excel macro
• › [Solved] Need a macro in Excel to total rows if their unique ID is th
• › How to send auto reminder in outlook if due date arrived?
• › Error 52 in Excel VBA - add columns to csv & resave as xlsx
• › [Solved] How to Excel to Count Values in 1 Column Based on 2 criteria