#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Thanks and Ah dam! Blocked due to security settings on my work PC. Back to the drawing board for me
|
#4
|
||||
|
||||
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 |
#5
|
|||
|
|||
I have found the reason why is that it's not "digitally signed" are you able to help with that?
|
#6
|
||||
|
||||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |