Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-01-2020, 03:04 AM
kincaidross kincaidross is offline Mail Merge 100 people in pairs Windows 10 Mail Merge 100 people in pairs Office 2016
Novice
Mail Merge 100 people in pairs
 
Join Date: Jul 2020
Posts: 3
kincaidross is on a distinguished road
Default Mail Merge 100 people in pairs


Good Morning, I was looking for a little help, I have a system in work whereby you "Match" with another colleague.

The data is presented to me in Column 1 being one email address, Column 2 being the next email address. I tried to concatenate the email addresses then use a mail merge to send to each "pair"

However this didn't work as it says MS Outlook doesn't recognize the emails with a semi colon in the middle.
Does anyone know a way around to send the same email to different pairs of people?

Thank you
Reply With Quote
  #2  
Old 07-01-2020, 05:23 AM
gmayor's Avatar
gmayor gmayor is offline Mail Merge 100 people in pairs Windows 10 Mail Merge 100 people in pairs Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,189
gmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of light
Default

If it helps, you could use E-Mail Merge Add-in to merge to e-mail with Column 1 as the Recipient and Column 2 as CC.
or you could use the rather more complex Merge Many To One in one to one mode (which emulates mail merge) and use your cocatenated fields separted with a semicolon and space as the recipient, and both addresses will go in the To 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
  #3  
Old 07-01-2020, 06:08 AM
kincaidross kincaidross is offline Mail Merge 100 people in pairs Windows 10 Mail Merge 100 people in pairs Office 2016
Novice
Mail Merge 100 people in pairs
 
Join Date: Jul 2020
Posts: 3
kincaidross is on a distinguished road
Default

Thanks and Ah dam! Blocked due to security settings on my work PC. Back to the drawing board for me
Reply With Quote
  #4  
Old 07-01-2020, 06:29 AM
gmayor's Avatar
gmayor gmayor is offline Mail Merge 100 people in pairs Windows 10 Mail Merge 100 people in pairs Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,189
gmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of light
Default

Ask your company IT support how you can do it without.
__________________
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
  #5  
Old 07-02-2020, 02:45 AM
kincaidross kincaidross is offline Mail Merge 100 people in pairs Windows 10 Mail Merge 100 people in pairs Office 2016
Novice
Mail Merge 100 people in pairs
 
Join Date: Jul 2020
Posts: 3
kincaidross is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
Ask your company IT support how you can do it without.
I have found the reason why is that it's not "digitally signed" are you able to help with that?
Reply With Quote
  #6  
Old 07-02-2020, 06:30 AM
gmayor's Avatar
gmayor gmayor is offline Mail Merge 100 people in pairs Windows 10 Mail Merge 100 people in pairs Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,189
gmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of light
Default

It's not cost effective to digitally sign an add-in that is essentially free to use, and which few outside the USA understand the value of donating to.
__________________
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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge 100 people in pairs Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge djrexy Mail Merge 1 05-20-2020 04:04 PM
VBA code to CC multiple people in mail merge by word kuankailok Mail Merge 3 05-04-2020 02:08 PM
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA RMerckling Mail Merge 16 05-17-2018 05:19 PM
My name as it shows up to people getting my mail john pearson Outlook 0 06-01-2016 12:00 AM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM

Other Forums: Access Forums - Senior Forums

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


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