How to Reuse Publisher Mail Merge Fields with Different Excel Files
Question details
The user needs a way to create a reusable template with built-in mail merge fields that persist when connecting a new Excel data source.

- Product
- Microsoft Publisher
- Device & OS
- not provided
- Scenario
- Switching to a new Excel spreadsheet data source for an existing mail merge document.
- Observed behavior
- Mail merge fields disappear when a second Excel spreadsheet is connected, even when the column headers in the new file are completely identical to the original.
Ensure that your new Excel spreadsheet has exactly the same column headers as the original data source and is closed before attempting to connect it to your document.
Reconnect Data Source and Reinsert Fields Manually
Because Publisher does not preserve unlinked merge fields reliably, the most consistent workaround is to reconnect the source and remap fields if they drop.
Microsoft Publisher requires an active, continuous connection to a data source to maintain merge fields. Changing the source file often breaks this link.
To ensure your document prints correctly, you must verify the connection each time a new spreadsheet is introduced.
Launch Microsoft Publisher and open the saved template file that contains your original layout.
Navigate to the 'Mailings' tab on the ribbon, click 'Select Recipients', and choose 'Use an Existing List'.
Browse your computer for the new Excel spreadsheet, select it, and click 'Open'. Choose the correct worksheet if prompted.
If Publisher removed your merge fields, place your cursor where the data should appear, click 'Insert Merge Field' in the Mailings tab, and select the corresponding header.

Maintain a Static Dummy Data Source
Prevent fields from disappearing by keeping the template permanently linked to a single Excel file, and simply pasting new data into that file.
Experience Seamless Mail Merge with WPS Office
Struggling with disappearing merge fields and rigid data source limitations in Microsoft Publisher? WPS Writer provides a robust, easy-to-use Mail Merge feature that flawlessly connects with Excel spreadsheets and preserves your templates without the hassle.
- 1. Prepare your template in WPS Writer: Open WPS Writer, create your document layout, and go to the 'References' tab to find the Mail Merge options.
- 2. Connect your spreadsheet: Click 'Open Data Source' and select your Excel or WPS Spreadsheet containing the recipient data.
- 3. Insert fields and merge: Use 'Insert Merge Field' to place your data points securely, then click 'Merge to New Document' to generate your final files.

Frequently Asked Questions
Why do my mail merge fields disappear when I change the Excel list?
Publisher requires an active connection to a data source to preserve merge fields. When you disconnect the original file to attach a new one, Publisher often removes unlinked fields to prevent formatting errors.
Do the column headers in my new Excel file need to match exactly?
Yes. Even slight differences in spelling, extra spaces, or capitalization can cause Publisher to reject the column header, resulting in dropped merge fields.
Can I create a Publisher template with merge fields but no attached spreadsheet?
Unfortunately, no. Microsoft Publisher does not reliably preserve reusable merge fields independently of a data source. You must have an initial spreadsheet connected in order to insert and save the fields.
How can I preview my merged data before printing?
In the Mailings tab, click the 'Preview Results' button. You can use the arrow buttons next to it to scroll through different records and verify that your fields mapped correctly to the new Excel data.




