How to Reconnect a Word Mail Merge to a New Database
Question details
The user needs to update an existing mail merge document to use a new data source, but it continues to display old results and prevents previewing new data.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Attempting to update the spreadsheet database for an existing mail merge document to generate new invoices or letters.
- Observed behavior
- The document displays old merge results, 'Preview Results' is unavailable, and 'Finish & Merge' remains associated with the previous output. This typically occurs when mistakenly using a completed multi-page output document rather than the original merge template.
Verify that you are opening the original primary mail merge template (usually a 1-page document with field tags) and not the final generated output document containing the finished pages.
Use the Original Primary Merge Document
To successfully attach a new database, you must apply the new data source to the original template rather than the previously completed output document.
A completed mail merge generates a brand new document containing the final results (e.g., 25 pages of invoices). This output document is just a standard Word document and cannot be used as the template for a new mail merge.
Find and open your original primary mail merge document. It should contain merge field placeholders (like <<Name>>) rather than actual data.
Click on the 'Mailings' tab located on the top ribbon menu.
Click 'Select Recipients' and choose 'Use an Existing List' from the dropdown menu.
Browse your computer files, select your updated spreadsheet or database, and click 'Open'.
Click 'Preview Results' to ensure the new data populates correctly, then proceed to 'Finish & Merge'.

Reset to a Normal Word Document Before Reconnecting
If the primary document is stuck or retains old database connections, converting it to a normal document first will break the old link so you can establish a fresh connection.
Perform Seamless Mail Merges with WPS Writer
WPS Writer offers an intuitive, highly compatible Mail Merge feature that seamlessly connects with WPS Spreadsheet and Excel data. It simplifies managing recipient lists and prevents frustrating database connection errors.
- 1. Open document in WPS Writer: Launch WPS Writer and open your mail merge template document.
- 2. Access Mail Merge tools: Navigate to the 'References' tab and click 'Mail Merge' to display the dedicated mail merge ribbon.
- 3. Open data source: Click 'Open Data Source', browse for your updated spreadsheet, and select it to link the data.
- 4. Preview merged data: Insert merge fields if necessary, then click 'View Merged Data' to check the new spreadsheet information.
- 5. Complete the merge: Click 'Merge to Different New Document' to generate the final pages with your updated database.

Frequently Asked Questions
Why is the 'Preview Results' button grayed out?
The 'Preview Results' button is typically unavailable if a valid data source has not been successfully connected to the document, or if you are viewing a standard document (like the final merged output file) instead of a primary merge template.
How do I know if I am in the primary merge document or the output document?
A primary merge document usually contains placeholder tags (like <<First_Name>>) and is only a few pages long. An output document contains actual data replacing the tags and is often much longer, reflecting the total number of records processed.
Can I change the data source without losing my merge fields?
Yes, as long as the new data source has the exact same column headers as the old spreadsheet, the application will automatically match your existing merge fields to the new data when you reconnect the database.
How do I edit the recipient list after reconnecting the spreadsheet?
Go to the Mailings tab and click 'Edit Recipient List'. In this dialog box, you can check or uncheck specific contacts, filter data, and sort records before finishing your merge.




