Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-17-2020, 07:56 AM
rossmyhill rossmyhill is offline Mail Merge without sending user multiple emails Windows 10 Mail Merge without sending user multiple emails Office 2019
Novice
Mail Merge without sending user multiple emails
 
Join Date: Sep 2020
Location: Essex, England
Posts: 2
rossmyhill is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 09-17-2020, 08:28 PM
gmayor's Avatar
gmayor gmayor is offline Mail Merge without sending user multiple emails Windows 10 Mail Merge without sending user multiple emails Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
  #3  
Old 09-18-2020, 01:11 AM
rossmyhill rossmyhill is offline Mail Merge without sending user multiple emails Windows 10 Mail Merge without sending user multiple emails Office 2019
Novice
Mail Merge without sending user multiple emails
 
Join Date: Sep 2020
Location: Essex, England
Posts: 2
rossmyhill is on a distinguished road
Default

Thank you for your reply. I didn't know the search terminology.

Ross
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge without sending user multiple emails 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft