Document Editing Problems

How to Reconnect a Word Mail Merge to a New Database

John WilsonJohn Wilson Nov 2, 2026 868 views

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.

How to Reconnect a Word Mail Merge to a New Database
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.
Before you start

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.

Solution 1Recommended

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.

1
Locate the primary document

Find and open your original primary mail merge document. It should contain merge field placeholders (like <<Name>>) rather than actual data.

2
Navigate to the Mailings tab

Click on the 'Mailings' tab located on the top ribbon menu.

3
Select a new recipient list

Click 'Select Recipients' and choose 'Use an Existing List' from the dropdown menu.

4
Attach the new database

Browse your computer files, select your updated spreadsheet or database, and click 'Open'.

5
Preview and finish

Click 'Preview Results' to ensure the new data populates correctly, then proceed to 'Finish & Merge'.

Use the Original Primary Merge Document
Identifying the Output Document: If the document you opened already contains numerous pages of completed records, it is the output file. You must find the original source file to run a new merge.
Easy Mail Merge with WPS Office

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. 1. Open document in WPS Writer: Launch WPS Writer and open your mail merge template document.
  2. 2. Access Mail Merge tools: Navigate to the 'References' tab and click 'Mail Merge' to display the dedicated mail merge ribbon.
  3. 3. Open data source: Click 'Open Data Source', browse for your updated spreadsheet, and select it to link the data.
  4. 4. Preview merged data: Insert merge fields if necessary, then click 'View Merged Data' to check the new spreadsheet information.
  5. 5. Complete the merge: Click 'Merge to Different New Document' to generate the final pages with your updated database.
Highly compatible with Microsoft Word (.docx) and Excel (.xlsx) file formats.Clear, step-by-step Mail Merge tools to prevent output file confusion.Free and lightweight office suite for Windows, Mac, and Linux.Easy recipient selection and real-time preview functionality.
microsoft office alternative - wps office

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.