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.
Similar threads
Thread starter Title 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
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
B How-to Mail Merge with an attachment? BCM (Business Contact Manager) 2
K Mail Merge to email with attachments Outlook VBA and Custom Forms 8
H Outlook - Mail Merge Outlook VBA and Custom Forms 1
T vba extract data from msg file as attachment file of mail message Outlook VBA and Custom Forms 0
J E-mail held in Outbox while Minimized Using Outlook 3
G Forward email body to other mail list directly from Exchange server Exchange Server Administration 1
T Outlook creates a copie of every mail I send Using Outlook.com accounts in Outlook 4
N Please advise code received new mail Using Outlook 0
M Outlook 2010 How could I globally redesign an outlook template form/region/inspector template used to display mail lists or an individual mails? Outlook VBA and Custom Forms 0
A How to stop user form from disapearing once mail window is closed? Outlook VBA and Custom Forms 0
M Outlook, send to > mail recipient - results in plain text email Using Outlook 1
R How to Sync *all* Google Workspace Mail Folders with Outlook 2019 (MS365) Using Outlook 3
S Outlook VBA How to adapt this code for using in a different Mail Inbox Outlook VBA and Custom Forms 0
E Having some trouble with a run-a-script rule (moving mail based on file type) Outlook VBA and Custom Forms 5
S Outlook email to configure setup for each mail Outlook VBA and Custom Forms 1
L Correct E-Mail Pulling Wrong Mail Using Outlook 5
S Outlook mail adressing stops after first match in GAL Using Outlook 0
P Outlook 2013 All imported Mail Rules in error when imported into new profile Using Outlook 5
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
S Outlook Macro to move reply mail based on the key word in the subjectline Outlook VBA and Custom Forms 0
MrMayor SENT mail not reloading to top?? Using Outlook 4
Terry Sullivan Sender Field Displays My E-Mail Address, Not My Name Using Outlook 1
ThinkToday Calculate reply time of outlook mail Using Outlook 1
B Outlook 2010 Opening Mail Attachment Using Outlook 2
e_a_g_l_e_p_i Is it possible it set the fonts used to read incoming mail Using Outlook 25
D Mail in Sent Items Gone Using Outlook 12
M Managing Gmail "All Mail" sync issues with IMAP Using Outlook 1
GregS Outlook 2016 Sent Mail absent from Sent Mail or Sent Items Folders Using Outlook 4
GregS Why is Outlook 2016 mail in Outlook.com? Using Outlook 1
S Outlook not receiving mail Using Outlook 1
Commodore Outlook (2013) issues with icloud.com mail Using Outlook 0
GregS Outlook 2016 iPhone won't download Outlook 2016 Mail. Using Outlook 0

Similar threads

Top