I need help creating invoices from a Very Jane CSV order report. I would just use mail merge, and format it, but the problem is that the person and their address is one one line, then each product they ordered is one the next line, and then another person, and so on. Word just treats each line as a person.

Example: (I can't show private data)


The real CSV is formatted exactly the same way. And yes, some of the fields don't have names because the customer didn't enter theirs.



All I want to do is make an invoice for each one with what they ordered, their address/email, and my address.