Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Mail merge separate recipients same file
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-08-2018, 01:21 PM
Cafeaulait Cafeaulait is offline Mail merge separate recipients same file Windows 10 Mail merge separate recipients same file Office 2016
Novice
Mail merge separate recipients same file 		 
Join Date: May 2018
Posts: 4
Cafeaulait is on a distinguished road
Default Mail merge separate recipients same file

How can I mail merge the same message to different recipients and add the same attachment to each message?
Many thanks
Reply With Quote
  #2  
Old 05-08-2018, 10:42 PM
gmayor's Avatar
gmayor gmayor is offline Mail merge separate recipients same file Windows 10 Mail merge separate recipients same file 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
It depends how many recipients are involved. If there number is relatively modest, add them to a distribution group and create one message with the group as the BCC recipient.

If you want personalised messages, or there are lots of recipients, list them in an Excel file and use http://www.gmayor.com/ManyToOne.htm to merge in one to one mode to e-mail.
__________________
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 05-09-2018, 01:17 AM
macropod's Avatar
macropod macropod is offline Mail merge separate recipients same file Windows 7 64bit Mail merge separate recipients same file Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Cross-posted at: https://social.technet.microsoft.com...nts-same-file?
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 05-10-2018, 09:17 AM
Cafeaulait Cafeaulait is offline Mail merge separate recipients same file Windows 10 Mail merge separate recipients same file Office 2016
Novice
Mail merge separate recipients same file 		 
Join Date: May 2018
Posts: 4
Cafeaulait is on a distinguished road
Default Cross posting
If users know that the question is on another site that will discourage them from answering.
I don't undertand why I received a message from Excelguru.ca, I never posted on that site.
Reply With Quote
  #5  
Old 05-10-2018, 09:18 AM
Cafeaulait Cafeaulait is offline Mail merge separate recipients same file Windows 10 Mail merge separate recipients same file Office 2016
Novice
Mail merge separate recipients same file 		 
Join Date: May 2018
Posts: 4
Cafeaulait is on a distinguished road
Default
Thank you very much for this, what is the difference between one to one and one to many?
Reply With Quote
  #6  
Old 05-10-2018, 02:11 PM
macropod's Avatar
macropod macropod is offline Mail merge separate recipients same file Windows 7 64bit Mail merge separate recipients same file Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Quote:
Originally Posted by Cafeaulait View Post
If users know that the question is on another site that will discourage them from answering.
Kindly read the Excelguru.ca link.
Quote:
Originally Posted by Cafeaulait View Post
I don't undertand why I received a message from Excelguru.ca, I never posted on that site.
AFAIK, you didn't receive a message from there and no-one here said you had posted there.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 05-10-2018, 08:00 PM
gmayor's Avatar
gmayor gmayor is offline Mail merge separate recipients same file Windows 10 Mail merge separate recipients same file 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
Quote:
Originally Posted by Cafeaulait View Post
Thank you very much for this, what is the difference between one to one and one to many?
One to one means one document per record. Many to One is one document per group of consecutive records with a common field.
__________________
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
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge separate recipients same file Microsoft Word VBA to save Word doc to separate PDF files using a Mail Merge field as File name meghanquint4 Word VBA 2 02-28-2018 07:12 AM
Mail merge separate recipients same file Mail merge result in separate world files instead of one file containing all the data xdhbsh Mail Merge 3 12-24-2015 12:23 AM
Mail merge separate recipients same file Creating separate file for each mail merge doshshirl Mail Merge 3 02-15-2014 08:49 PM
Mail merge separate recipients same file mail merge multiple recipients per page bmobrien Mail Merge 3 02-23-2012 10:47 PM
Mail merge separate recipients same file Mail Merge Recipients List TanMan Mail Merge 1 10-13-2011 06:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:27 AM.

Contact Us - Privacy Statement - Top

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