Mail Merge In Outlook 2007
Learn how to send mass emails to a list of email addresses stored in Excel. Use Word to create a form, select a file from Excel, and send the mail through O. Click the Email Merge Wizard button on the Ribbon. Follow the easy steps in the Wizard to create your email and to choose your Excel file from the previous step as you list source/ When you come to the following screen, select the main recipient’s details from the drop-down fields and then click Select fields Attachments/CC/BCC.
This article will show how to easily add Cc and Bcc recipients while mailing the merged document. There is no such build-in option in Microsoft Office but using Mail Merge Toolkit you can send Carbon and Blind Carbon Copies. Just specify secondary and hidden recipients the same way as in regular Outlook messages.
But what’s the point of sending copies of personalized emails in the first place?
The main idea of Cc is to make all recipients aware of getting the same message. And later by using the Reply All option, people from this email thread can be involved in the future conversation. This is especially useful for related contacts like a recipient, and recipient`s assistant, or student, and parent, or client, and account manager, etc.
On the other hand, Bcc allows the opposite scenario, by hiding additional recipients from anyone listed in the To and Cc fields in order to protect the privacy of email addresses and names.
This can be used in both internal and external communications.
Add CC or BCC recipients in a Mail Merge
How To Do Mail Merge In Outlook
Let’s imagine a scenario, that we need to send personalized mailout to sales managers. We also need to send a carbon copy to corresponding supervisors. And a special archiving email address must be specified in the blind carbon copy field, hiding it from other recipients.
So first, we add email addresses for the Cc field to the data source.
Then, after finishing the mass email template in Microsoft Word or Publisher, open advanced mail merge features by clicking Merge and Send. Here you will find all new settings added by the Mail Merge Toolkit.
Here, in the Message settings, two ways of adding secondary recipients available:
- Personalize Cc and Bcc using Merge Fields that will be replaced by addresses from a data source. In this case, supervisors will get a copy of a specific message only.
- Add a specific email address, so this recipient will receive a copy of all the emails.
If you want to add multiple addresses, separate them with a semicolon.
After hitting the Send messages button, multiple personalized emails with specified Cc and Bcc recipients will be created and sent using Microsoft Outlook.
Video Tutorial and Walkthrough: Mail Merge with Carbon and Blind Carbon copy
Learn more about other features of Mail Merge Toolkit or download and try it yourself.