That should be straightforward, if the data is as displayed all you should need is the Split function to get the data for each row then each field.
Do you already have code to get the body of the email?
Where would the data go in Excel, a new workbook or an existing workbook?
reitzen
If the email is text (not html) and all your column widths are fixed, you could easily replace the spaces using SUBSTITUTE and use MID to grab your column data...without using VBA. Just a thought.
Do you already have code to get the body of the email?
Where would the data go in Excel, a new workbook or an existing workbook?