0
I have a table that looks somewhat like this:
User Email | Invoice Number | Company
A@as.com 12 xyz
A@as.com | 13 | yyy
B@as.com | 112 | add
When I do mail merge, I do a merge field on invoice number and company and send it to the user's email. This results in A@as.com getting 2 emails for 2 different invoices; is there a way to automatically send 1 email instead?
A current solution I have is to have multiple 'invoice number' columns and transpose the column based on the user's email, however that way I lose information on which company the invoice belongs to. Is there a better way?
What version of Office are you using? – CharlieRB – 2017-08-08T11:35:59.267
@CharlieRB 2013 :) – Evil Washing Machine – 2017-08-09T13:43:16.187