Hello,

Can someone please help, I've been trawling the internet for far to long trying to find a solution.

I'm looking to create a letter using data from excel. The data contains multiple customers with some rows that are the same customer. Those same customers have varying invoice lines. I want a letter to be generated to mail the customer to make them aware of their open invoices, so I want them to group together.

E.G my date has the fields Customer number, Customer Name, Address 1,2,3,Invoice number, Date, amount.

I'd want to list someone their open invoices in a table if need be, but only get one letter for each customer detailing all their outstanding invoices.

Sorry this is hard to put into words! Please help XD