Pull data from table in email into lines in excel

Hello,

I have a daily email that spits out certain information in a table (data includes name, address, date of transaction, sales person on the transaction, etc. etc.). This email is a daily alert. I must record each set of data into a single line on an excel spreadsheet (one line for each transaction).

The problem I have is that the original table in the email I receive is irregular. Some of the data in the table comes in one cell, and other cells below it are split into two. Therefore, when they are copied into Excel, I don't have all the data in one column- The data is in two columns. Furthermore, the email it originates on has irregular formatting. A line is inserted between SETS of data for each sales person- not between EACH data table (for instance, if one sales person has multiple alerts, they are grouped together (with NO line in between). I cant find an easy way to pull this info automatically into my spreadsheet. Maybe you guru's have a better idea?

I have attached a PDF sample of the email I receive. One sample is the email as it comes. Another has all of the outlines for the tables shown so you can see how it is broken up.

I am hoping for the **simplest** way to achieve this. I have no experience writing macros. Perhaps there is a way to copy and paste the entries into a sheet in Excel and then get it to pull the data after a certain keyword (like Name: or Address and then switch the data on the sheet I need to keep to values, then paste/pull the data/repeat? Any ideas? I only need to pull the date of the email, Loan Date, Branch Code, Name, Reported Name, Address, City, State, Zip.

I have uploaded the screenshots of the data here. Hopefully I got all of them - the photo uploader is a bit clunky on here!

Thank you in advance for your help!


Email Received:

Trigger Email Screenshot.JPG



Table in Email:
Trigger Email with Tables Close-Up Screenshot.JPG



Excel Destination:
Trigger Email Destination Spreadsheet Screenshot.JPG

I would, but the file uploader is not working on this forum (in either Chrome or IE). I can copy the text directly into this post though (which probably doesn't help you...)

Name : Borrower Name
Reported Name : Borrower Name
Address : 1234 Address, City, State, 99999
Reported Address : 1234 Address, City, State, 99999
FICO Score : 000
Sales Person : Sales Person Loan Origination Date : 12/7/2020
Branch Code : NEV
LO Email : sales.person@company.net


Name : Borrower Name
Reported Name : Borrower Name
Address : 1234 Address, City, State, 99999
Reported Address : 1234 Address, City, State, 99999
FICO Score : 000
Sales Person : Sales Person Loan Origination Date : 12/3/2020
Branch Code : WAS
LO Email : sales.person@company.net