Template Issues

How to Fix Word Mail Merge Templates Opening as Merged Documents

Rana Garcia Oct 22, 2026 868 views

Question details

The user needs to resolve an issue where Word mail merge templates open displaying previously merged letters instead of the base template.

How to Fix Word Mail Merge Templates Opening as Merged Documents

Product: Microsoft Word
Device & OS: not provided
Scenario: Opening a mail merge template that utilizes IF fields and INCLUDETEXT functions.
Observed behavior: The template incorrectly displays data from past merges rather than remaining a blank template. Word also prompts the user to connect to the original data source, and selecting either option can result in losing the template structure entirely.

Before you start

Before making changes to your mail merge setup, ensure you have a backup copy of your original document and your data source file to prevent accidental data loss during troubleshooting.

Solution 1Recommended

Use a Standard Document Format and Reconnect Data Source

Saving your mail merge file as a standard document format prevents Word from locking into previously merged states often associated with template file extensions.

Mail merge main documents function much better as standard documents (.doc, .docx, .docm) rather than strict template formats (.dot, .dotx, .dotm).

Convert Template to Document

Open your problematic template file and use 'Save As' to save it as a standard Word document (.docx or .doc) instead of a template format.

Accept Data Source Connection

When reopening the file and Word asks whether it should connect to the original data source, select 'Yes'.

Select Your Recipients

Navigate to the 'Mailings' tab on the top ribbon, click on 'Select Recipients', and choose 'Use an Existing List' to re-link your correct data source.

Use a Standard Document Format and Reconnect Data Source

Using a Dummy Data Source: If you are designing the template and do not have the final data yet, create a dummy source with the required column names and at least one row of data. This allows you to construct and preserve your mail merge rules and IF fields without errors.

Solution 2

Correctly Generate Output and Manage INCLUDETEXT

Ensure that your final merges are saved as completely separate documents and that any nested INCLUDETEXT files are disconnected from data sources.

Seamless Mail Merge

Easily Manage Mail Merge Templates with WPS Office

WPS Writer provides a highly stable Mail Merge environment that prevents templates from permanently locking into merged states. Easily create rules, insert fields, and generate bulk letters with a lightweight tool.

1. Open Your Main Document: Launch WPS Writer and open your mail merge main document.
2. Access Mail Merge Tools: Navigate to the 'References' or 'Mailings' tab in the top ribbon and click on 'Mail Merge' to reveal the toolbar.
3. Connect Data Source: Click 'Open Data Source' and select your spreadsheet or database to securely link your recipient list.
4. Merge to a New Document: Once your fields are set, click 'Merge to Different New Document' to generate your customized letters without overwriting your blank template.

Fully compatible with Microsoft Word .docx, .doc, and data source formatsIntuitive Mailings tab simplifies data source connectionsStable field code processing prevents template corruption during complex mergesFree and lightweight alternative to heavy office suites

microsoft office alternative - wps office

Frequently Asked Questions

Why does Word keep asking to connect to the data source when I open my template?

Word intentionally links mail merge documents to their specific data sources. When opened, it attempts to execute SQL commands to pull the latest data. If the file is saved as a template (.dotx) instead of a standard document, this process can malfunction and mistakenly display previously merged results.

Can I safely use INCLUDETEXT in a mail merge document?

Yes, INCLUDETEXT fields can pull in external content during a merge. However, it is critical that the external files being pulled in are not themselves configured as mail merge documents connected to a data source, as this will cause recursive errors.

How can I set up mail merge IF fields if my final data source isn't ready?

You can create a temporary or 'dummy' data source. Open Excel or a blank Word document, create a simple table containing the exact column headers your merge requires, and fill out one row of test data. Connect this dummy file to your main document to successfully build and save your IF rules.

Document & File Issues