Add Optional Department Fields to a Word Mail Merge Address
Question details
Add an optional department or job title from an Excel data source to a Word mail merge address.

- Product
- Microsoft Word Mail Merge
- Device & OS
- not provided
- Scenario
- A user is creating address blocks from an Excel recipient list and needs to include fields that are not clearly available in Word's Address Block.
- Observed behavior
- Word's Address Block does not provide a clear way to add custom fields, and internal names such as _DEPARTMENT_ are not reliable merge fields.
Check that the Excel recipient list has a clearly named column, such as Department, with a value for each recipient who needs one. In Word, connect the list through Mailings > Select Recipients and verify the column name under Mailings > Insert Merge Field.
Build the address with individual merge fields
Use fields from the recipient list instead of trying to customize Word's Address Block.
In Word, open the merge document and select Mailings > Select Recipients > Use an Existing List. Choose the Excel file and the worksheet containing the recipient data.
Place the cursor where the address should appear. Use Mailings > Insert Merge Field to insert the name, Department, street, city, and other fields from the list, arranging them on separate lines as needed.
Select Mailings > Preview Results and use the recipient navigation arrows to check records with and without a Department value. Adjust line breaks and spacing as needed.
Select Mailings > Finish & Merge, then choose Edit Individual Documents or Print Documents.

Use an IF field to conditionally display the department
Use a conditional field when you need explicit control over whether the department text appears.
Create Mail Merge Documents with WPS Writer
WPS Office is a free, lightweight alternative with a familiar interface for working with documents and recipient lists. Open existing Office files in WPS to continue your work; it does not change the behavior of Microsoft Word's Address Block.

Frequently Asked Questions
Can I add a custom Department field directly to Word's Address Block?
Word does not provide a way to add custom fields directly to the Address Block. Instead, use Mailings > Insert Merge Field to build the address from individual fields.
Why doesn't _DEPARTMENT_ work as a merge field?
_DEPARTMENT_ is an internal Address Block name, not a reliable field from your data source. Use the actual column name shown under Mailings > Insert Merge Field.
Can I include a job title as well as a department?
Yes. Add a Job Title column to the recipient list, reconnect or refresh the list if needed, and insert it through Mailings > Insert Merge Field.
How can I check addresses when the Department column is blank?
Select Mailings > Preview Results and move through recipients with the navigation arrows. Check both populated and blank Department records for unwanted spacing or line breaks.




