Mail Merge

[ryan7]

Below is a small extract a from a list of account numbers and corresponding invoices and values.
I want to do a mail merge so that all invoices relating to one account are listed with their values rather than an individual email for each transaction.
Is there a solution to this?

Account No	Invoice	Value
123456​	B456	3.00​
123456​	B758	4.00​
123456​	C99	3.99​
55555​	D1	1,200.00​
55555​	C684	987.00​
55555​	C98	43.00​
55555​	X44	999.00​
75269​	G66	74.00​
75269​	G66R	4.12​

thanks

 

[Macropod]

See: Mail Merge Multiple Rows into one based on multiple columns