Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-11-2017, 02:12 AM
ThomasOtte ThomasOtte is offline Windows 8 Office 2013
Novice
 
Join Date: Jan 2017
Posts: 1
ThomasOtte is on a distinguished road
Default Using multiple recipients for one message in Merge

Dear all,



Situation:

I want to send 30 emails.
I use MS Excel as a database to fill the fields in my template message.
Fields are: First name, sex, content message, email address

Some of the 30 messages have to go to 1 recipient.
Others have to go to 2 recipients.

I have tried to add a second email address to the column "email address" in MS Excel with a semicolon, e.g. "john@123.com; sarah@123.com".
When finalising the Merge in MS Word, this produces an error. I am informed that Outlook "does not recognize john@123.com; sarah@123.com as an email address.

Can you maybe help me with this issue, either by directing me to an existing thread or by giving me instructions how to solve this problem?

Many thanks in advance, I hope the situation is clearly phrased like this.

Best,
Thomas
Reply With Quote
  #2  
Old 01-12-2017, 01:50 AM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,326
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You can't use multiple email addresses for the recipient field in a merge to email. Instead, you'd have to drive the process via a macro that automates Outlook (for example). For an example of such code, see:
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm
You can modify that as described at:
http://www.wordbanter.com/showthread.php?t=58331
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 01-12-2017, 05:28 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,165
gmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the rough
Default

You might consider http://www.gmayor.com/ManyToOne.htm which while not a true mail merge, will emulate one and you can merge the same message to multiple recipients. From your description you probably need the one to one merge to e-mail option.
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
merge, multiple recipients
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple recipients of mail kaspar Outlook 3 08-29-2013 06:37 AM
mail merge multiple recipients per page bmobrien Mail Merge 3 02-23-2012 10:47 PM
Mail Merge Recipients List TanMan Mail Merge 1 10-13-2011 06:36 PM
Cannot see all recipients in "to" field in new mail message (Outlook 2007) sinjinx Outlook 0 12-15-2010 08:13 AM
Multipe emails to multiple recipients BillNugent427 Outlook 0 03-19-2010 06:52 PM


All times are GMT -7. The time now is 10:00 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft