Add Department CC Recipients to a Word and Excel Mail Merge
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.

- 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.
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.
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.
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.
Write the message and use Mailings > Insert Merge Field to add fields such as the employee's name or department.
Select Mailings > Preview Results and check the personalized messages. Use a small test list with addresses you control before sending to employees.
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.

Use a Windows Mail Merge Add-In for Department-Specific CC
Use a reputable add-in when each merged message must include a CC address based on its department.
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.

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.




