During a mail merge, how to send a single email to a user instead of multiple ones?

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?

Evil Washing Machine

Posted 2017-08-08T11:28:14.013

Reputation: 208

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

No answers