Others

Add Department CC Recipients to a Word and Excel Mail Merge

Maira MehtabMaira Mehtab Nov 14, 2026 868 views

Question details

The user wants to send Word mail merge emails using Excel data and assign CC recipients by department without exposing employee email addresses unnecessarily.

Add Department CC Recipients to a Word and Excel Mail Merge
Product
Microsoft Word, Excel, and Outlook
Device & OS
not provided
Scenario
Sending department-related messages to employees from an Excel recipient list, with different CC recipients for each department.
Observed behavior
Word's standard email mail merge does not provide a simple native option for assigning different CC recipients by department.
Before you start

In Excel, put unique, descriptive field names in the first row, including employee email and department fields; add a department CC email field if you plan to use an add-in. Check the addresses and prepare a small test list before sending.

Solution 1Recommended

Send Individual Mail Merge Emails Without CC

Use Word's standard email merge when department CC recipients are not essential and you want to avoid listing employees together.

1
Connect the recipient list

In Word, open the message document and select Mailings > Start Mail Merge > E-mail Messages. Choose Select Recipients > Use an Existing List and select the Excel workbook.

2
Insert merge fields

Write the message and use Mailings > Insert Merge Field to add fields such as the employee's name or department.

3
Preview and test

Select Mailings > Preview Results and check the personalized messages. Use a small test list with addresses you control before sending to employees.

4
Send individual messages

Choose Mailings > Finish & Merge > Send E-mail Messages. Select the employee email field in the To box, enter a subject, and send through the configured Outlook profile.

Send Individual Mail Merge Emails Without CC
CC is not included: The standard Send E-mail Messages dialog does not assign a different CC recipient for each row. Use an add-in if department-specific CC is required.
Free Microsoft Office alternative

Work with Mail Merge Documents in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Its Microsoft Office format compatibility helps you move existing files into your workflow, although it does not fix Word's department-specific CC limitation.

Work with documents and recipient spreadsheets in one office suiteCompatible with Microsoft Word DOCX and Excel XLSX formatsFamiliar editing tools make it easier to move from Microsoft OfficeFree and lightweight for everyday document and spreadsheet work
QA img-9

Frequently Asked Questions

Can Word's standard mail merge add a different CC address for each department?

The standard Mailings > Finish & Merge > Send E-mail Messages dialog does not provide a simple per-row CC option. A compatible third-party add-in may support mapping an Excel column to CC.

How can I keep employee email addresses from being visible to other employees?

Send a separate merged message to each employee by selecting the employee email column in the To box. Check any CC addresses because they are visible to the recipient.

Can I use a department distribution list instead?

A department distribution list or LISTSERV can simplify group delivery. Check its membership and privacy settings with the list administrator, since address visibility depends on how the list is configured.

What should I check before sending the full merge?

Verify the Excel column headers and email addresses, use Mailings > Preview Results, and send a small test to addresses you control. If you used a temporary Outlook rule, disable it after the merge.