#1
|
|||
|
|||
Mail Merge without sending user multiple emails
Hi all, I've been sifting through the internet and on here for a week now trying to find an answer or solution to my problem. I want to send a mass of emails to our users that displays their vehicle registration, their business name and their MOT expiry date.
I have an excel sheet showing these details also with their email in the next column. The problem I have is that the same user may have many vehicles (some over 1000) which means that when I try to use mail merge it will send that user 1000 separate emails, which I am sure they would not be happy with. The spreadsheet looks something like this: Name Vehicle id expiry email jbloggs 123456 30/03/20 123@456.com jbloggs 2345612 03/03/19 123@456.com jbloggs 81818313 01/01/20 123@456.com So you get the gist that the email could be listed multiple times but the data on each row is different. Hope this makes sense. Regards Ross |
#2
|
||||
|
||||
What you are describing is a many to one mail merge - see Merge Many To One Sort the data by user
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Thank you for your reply. I didn't know the search terminology.
Ross |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help Sending Mail Merge Document | dazwm | Mail Merge | 8 | 01-28-2014 01:00 PM |
Edit Multiple Emails' User-Defined Field | ryancaseymcshane | Outlook | 0 | 10-04-2011 07:40 AM |
sending Emails With Mail-Merge As HTML Problem - Nothing Happen | majid000 | Mail Merge | 0 | 12-10-2010 07:51 AM |
Outlook sending multiple emails | Shawn76 | Outlook | 0 | 08-07-2010 09:10 AM |
Outlook sending multiple copies of some emails | Shawn76 | Outlook | 0 | 05-20-2010 12:40 PM |