How to add cc in mail merge outlook

To add a CC (Carbon Copy) recipient in a mail merge using Outlook, you can follow these steps:

Method 1: Using the Mail Merge Wizard

1. Open your Outlook email and click on the "Mail Merge" button in the "Home" tab of the ribbon.
2. Select "Step-by-Step Mail Merge" and follow the wizard to create your mail merge.
3. In the "Select Recipients" step, click on "Use an existing list" and select your recipient list.
4. In the "Write your message" step, click on the "Insert Merge Field" button to insert the recipient's name, email address, or other fields.
5. To add a CC recipient, click on the "To" field and select "CC" from the dropdown menu.
6. Enter the email address of the CC recipient in the "CC" field.
7. Click "Next" to proceed with the mail merge.

Method 2: Using the Outlook Address Book

1. Open your Outlook email and click on the "To" field.
2. Click on the "Address Book" button in the "To" field dropdown menu.
3. Select the recipient you want to add as a CC recipient from the address book.
4. Right-click on the selected recipient and select "Add to CC".
5. Repeat the process to add multiple CC recipients.
6. Click "OK" to close the address book.

Method 3: Using VBA Code

1. Open the Visual Basic Editor by pressing "Alt + F11" or by navigating to "Developer" tab in the ribbon.
2. In the Visual Basic Editor, click on "Insert" > "Module" to insert a new module.
3. Paste the following code:

   Sub AddCCRecipient()
    Dim olApp As New Outlook.Application
    Dim olMail As Outlook.MailItem
    Set olMail = olApp.CreateItem(0)
    olMail.To = "[email protected]"
    olMail.CC = "[email protected]"
    olMail.Send
   End Sub

4. Replace "[email protected]" with the email address of the primary recipient and "[email protected]" with the email address of the CC recipient.
5. Click "Run" to execute the code.

Note: The above code assumes you have Outlook 2010 or later version. For earlier versions, you may need to use a different code.