Mail merge to single contacts + contact groups?

Status
Not open for further replies.

mr_malkovich

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Hi all. I think I asked this question years ago on this forum (because it's the best Outlook forum there is) but since it's been a while I'll ask again because things may have changed. Is it yet possible using code or an add-in to do a mail merge to a mixture of contacts and contact groups? Some organizations actually prefer to receive an email in tandem with their other colleagues. Also, it eliminates me sending several people in the same organization receiving an almost identical email and looking like a prat. Thanks in advance..
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I don't have a macro that does both (Actually i do, but forgot :)), but i do have one that does contact groups. Actually, two - one to merge to contact groups, one merges to members of contact groups.

Mail merge to members of a contact group <== this is a basic proof-of-concept demo macro. Select a contact group, run the macro and a message is created for each.

Mail Merge to Contact Groups <== this can do both groups and contacts. Create the message, add the recipients then run the macro to send the message individually to each recipient. Delete this 'merge template' message.
 

mr_malkovich

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Thanks for your reply Diane. The second one looks up my alley. Can the message be personalized like regular Mail Merge, say, to include the Company name in the body text? <Company> etc..
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
short version, no, not by pulling anything from the contact as the macro is currently written. if everyone is from the same company, then yes. :)

long version, yes, but you need to add code to lookup each contact. i don't have a macro that does this for mail merge but do have some that look up contacts. The example at the end of Create a List of Meeting Attendees and Responses shows how to look up the contact and grab fields - the macro at Mail Merge to Email using an Outlook Macro shows one way to merge, or use Replace to replace unique keywords (Replace(item.body, "xxxcompanyxxx", ocontact.company). Word's search and replace function should work too. (ah, the benefits of word as the editor).
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
K Delay Send and Mail Merge Outlook VBA and Custom Forms 4
Diane Poremsky Add Attachments and Set Email Fields During a Mail Merge New Slipstick.com Articles 0
iwshim outlook mail merge -rich text Using Outlook 2
Diane Poremsky Add attachments and set email fields during a mail merge to email New Slipstick.com Articles 0
H Mail Merge status remaining "Not Executed" BCM (Business Contact Manager) 1
iwshim mail merge and add the contact picture outlook 2013 Using Outlook 3
A Reply/Forward Emails using Mail Merge BCM (Business Contact Manager) 0
S Custom field not populating in Custom View or Mail Merge Exchange Server Administration 2
W Combine Mail Merge to Distribution List with Auto Attachments - Outlook 2007 Using Outlook 1
M Using mail merge with stationery Using Outlook 5
P Mail Merge vs Direct Mail Print BCM (Business Contact Manager) 4
A Mail Merge - Sent but still in Outbox Using Outlook 5
R specify from account in mail merge Using Outlook 3
G Mail Merge via Proxy Email? Using Outlook 2
A Outlook 2007 Mail Merge not working anymore Using Outlook 1
J Contacts Notes field will not mail merge after migration to Exchange 2010 Exchange Server Administration 1
D Publisher 2010 (x64) not connecting with Outlook 2010 (x64) via Mail Merge Using Outlook 1
J Mail merge, labels, contact lists, address block Using Outlook 2
F Office 2010 Mail merge into Work 2010 using a specific Outlook catagory filter. Using Outlook 2
F Attachments (such as pdf) in a mail merge Outlook 2010 Using Outlook 1
F Mail merge in Word/Outlook 2010 using multiple email accounts in Outlook Using Outlook 2
J mass email limitations when sending mails using mail merge. Using Outlook 2
S Merge Outlook mails to Windows Live Mail Inbox Using Outlook 4
H Mail Merge Contacts Using Outlook 4
T User-defined fields in Outlook to be incorporated into Mail Merge documents Using Outlook 1
I E-mail Merge with Word/Outlook 2010 Exceptionally Slow Using Outlook 3
C Issues with ctearing mail merge file with Outlook 2010 &amp; Win 7 Using Outlook 1
M Mail Merge email using data from MS Access Using Outlook 1
A Using Mailing Address in Mail Merge with BCM Using Outlook 1
V Outlook 2010 - attachments with mail merge email Using Outlook 4
1 MAIL MERGE NOT WORKING Using Outlook 5
G Problems Sending Publisher Mail Merge Newsletters Through Outlook. Using Outlook 1
B Subject heading with mail merge Using Outlook 2
D Mail merge to create labels for Outlook contacts DOES NOT WORK Using Outlook 3
L mail merge trouble 2003 - sends only 2 out of 150+ entries in data file Using Outlook 1
C Mail Merge using Excel File Using Outlook 1
N Choosing an email account during mail merge Using Outlook 3
L E-mail merge: How can I use the “Direct Replies To” option in Outlook when I’m doing an e-mail merge from Word? Using Outlook 3
A Outlook 2007 BCM mail merge Using Outlook 1
L mail merge with outlook contacts Using Outlook 2
A Should emails sent through the mail merge feature end up in my sent folder? Using Outlook 3
2 Lost attachments with mail merge Using Outlook 1
B How do I select who the email is coming from and who replies go to for a mail merge? Using Outlook 1
A Inserting an unsubsribe link a Mail merge (Microsoft word 2003) Using Outlook 1
R Outlook 2007 contacts mail merge to lables Using Outlook 3
B Mail Merge won't email Using Outlook 2
K Mail merge delivery delayed Using Outlook 1
S mail merge and cc Using Outlook 2
A E-Mail Merge to All E-Mail Addresses on One BCM Contact BCM (Business Contact Manager) 1
G VBA Interfering with Email Addresses in Mail Merge? Outlook VBA and Custom Forms 2
Similar threads


















































Top