Excel & Outlook 2013 - Import email body lines into columns

Hello,
I manage a mailbox where employees submit leads from an intranet form that is filled out then submitted via email. I get about 10 to 20 emails a day and need them all processed when I open the workbook and import them. I've searched all over and cannot find anything that will work for what I need.

I found the code below and it works well for the header info. but puts all the body info into one cell. I need it to put each line of the body into a new column and I only need the "Sender" from the header.

The body of the email contains the info. from the form. I need each line from the form in separate columns. I need the info after the colon of each line and some may be left blank. The column headers are below and I don't really need every line. I have noted the lines I don't need, but listed all in case it affects the code. I'm including a snapshot of the email body.

Associate Name: '--not needed
Associate Title: '--not needed
Associate ID:
Associate Branch: '--not needed
Associate Phone #: '--not needed
Email Address:
Company/Customer:
Customer Address:
Customer City/State:
Site #:
Contact Name:
Contact Title:
Contact Email:
Contact Phone:
Lead Location:
Product Services:
Additonal Comments:


Outlook_Import.jpg

Please Login or Register  to view this content.

Can anyone help?