Hi All,

I am hoping someone can assist me asap on the below issue.

I am trying to email customers with details of products they owe payment. I am using NEXTIF and SET ID codes in mail merge tool and trying to group the multiple rows by customer to send one email per customer but facing problems as lines keep duplicating. Below is an example table.

Customer Product Price Primary Email Secondary Email
Clare Product 1 120 XYZ@DXB.com muskhal17@hotmail.com
Clare Product 2 130 XYZ@DXB.com muskhal17@hotmail.com
Dave Product 3 140 XYZ@DXB.com muskhal17@hotmail.com
Sean Product 4 150 XYZ@DXB.com muskhal17@hotmail.com
Sean Product 5 160 XYZ@DXB.com muskhal17@hotmail.com
Sean Product 6 170 XYZ@DXB.com muskhal17@hotmail.com
Sean Product 7 180 XYZ@DXB.com muskhal17@hotmail.com
John Product 8 190 XYZ@DXB.com muskhal17@hotmail.com
John Product 9 200 XYZ@DXB.com muskhal17@hotmail.com

If someone is able to assist asap on this it would be much appreciated.

Thnx