Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

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

Dear all,


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. ";".
When finalising the Merge in MS Word, this produces an error. I am informed that Outlook "does not recognize; 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.

Reply With Quote
Old 01-12-2017, 01:50 AM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,420
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

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:
You can modify that as described at:
Paul Edstein
[MS MVP - Word]
Reply With Quote
Old 01-12-2017, 05:28 AM
gmayor's Avatar
gmayor gmayor is online now Windows 10 Office 2016
Join Date: Aug 2014
Posts: 1,884
gmayor will become famous soon enoughgmayor will become famous soon enough

You might consider 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
Reply With Quote

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 06:43 AM.

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