To, CC and BCC should contain email addresses separated by a semi-colon (multiple columns can be used if preferred).

Add any of the following columns to your Mail Merge data: To, CC BCC, Subject, Importance, Sensitivity, ReadReceipt, DeliveryReceipt, DeliveryTime,FollowUp, Account, SendAs, Attachment.

Copy the text of the Macro from below and add to Word.

If you are not a user yet, you can download a fully functi onal 30 day trial to test it for yourself. Use the screen that comes up to select the field in which the CC email address is contained.įollow the rests of the steps of the Wizard to send out the emails.Īnd that’s it….thousands of users use EmailMerge for Outlook everyday to send out their sales and marketing emails. 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. 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/

You will need to download and install Email Merge Pro for Outlook to add the functionality inside Outlook for you (Unfortunately there is now built-in way in Microsoft Outlook to do what is needed).Ĭlick the Email Merge Wizard button on the Ribbon. Step 2: Use EmailMerge to send out the emails In this example I will be sending an email to a customer and CCing their assistants. The easiest way to do this is in Excel as shown below. The first thing you need to do is create a list of people to send the email to. Now that we have got that out of the way, let’s see how easy it is to do this. It is easy to have a “conversation” by doing a Reply-All.They’re all now aware exactly who received the emails and.It is better having related people on the same email because:

Step 0: Why not just send each person a separate copy of the same email? In this post, I will show you why and how to do this. Statements to clients, and CC their accounts managers on the same email.Event reminders to attendees, and CC their assistants.Emails to people in your company and CC their managers/supervisors.Announcements to important clients, and CC each client’s assistant on the same email.Do you need to send an email to a list of people AND also CC/BCC a related contact on each email?

How to do a mail merge in outlook