This has two areas i’m struggling with, how to get the body of the emails into an excel sheet in the correct columns, and how to put this data into the next empty row in the excel sheet. I have worked with finding empty rows before but never combining this with placing data from emails into correct columns and an empty row.
Here is what the email looks like and is always in this exact format:
Here are the headers for the excel document:
My idea is to iterate through the emails getting the body, pasting it in the spare excel sheet, re-organise it, and then use a for each row to find the next empty row, and paste the data into there. Then repeat for the next email.
I’d be grateful for any help.