Document Editing Problems

How to Change the Mail Merge Data Source Location in Word

Maira Mehtab Sep 28, 2026 871 views

Question details

The user needs to update the file path for an Excel data source linked to a Word mail merge document after moving the files to a new computer.

Product: Word
Device & OS: not provided
Scenario: Moving mail-merge files and their linked Excel data sources to another computer or directory.
Observed behavior: Word continues trying to connect to the original file path instead of recognizing the new location of the Excel data source.

Before you start

Ensure you know the exact folder location of your moved Excel data source file on your new computer before opening the Word document.

Solution 1Recommended

Disconnect the Old Source and Select the New Location

Disconnect the broken link when prompted upon opening the document, and manually re-link the Excel file from its new directory.

Microsoft Word uses absolute file paths to remember where your mail merge data is stored. When you move the document and data source to a new computer, the file path changes, and Word cannot find the original data automatically. You must break the old connection and establish a new one.

Disconnect the old data source

Open your Word mail-merge document. When the SQL prompt appears asking if you want to run the SQL command to connect to the data, select 'No'. This safely disconnects the document from the old file path.

Navigate to the Mailings tab

Once the document is open, go to the top ribbon and click on the 'Mailings' tab.

Select the new recipient list

Click on 'Select Recipients' and choose 'Use an Existing List' from the drop-down menu.

Locate and open the new data source

Browse your computer's folders to find the Excel file in its new location. Select the file and click 'Open', then choose the correct worksheet if prompted.

Save the document

Save your Word document immediately. The new data-source path is now retained, and the document will open correctly in the future without the SQL error.

Path Updated Successfully: By saving the document after linking the new Excel file, Word overwrites the old absolute path with the new one.

Seamless Mail Merge with WPS Office

Perform Mail Merge Effortlessly in WPS Writer

WPS Writer provides an intuitive and fully compatible Mail Merge feature, making it easy to link, update, and manage Excel data sources without hassle.

1. Open Mailings: Open your document in WPS Writer and navigate to the 'Mailings' tab on the ribbon.
2. Open Data Source: Click 'Open Data Source' to browse your computer and select your Excel list.
3. Insert Fields: Use 'Insert Merge Field' to place data exactly where you need it in the document.
4. Merge and Finish: Click 'Merge to New Document' or 'Merge to Printer' to complete your mail merge.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Intuitive Mail Merge wizard for easy data linking and field insertion.Easily update or change data source paths without complex SQL prompts.Lightweight application with fast document loading speeds.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Word mail merge lose its data source when I email the files?

Word uses absolute file paths (e.g., C:\Users\Name\Documents\data.xlsx) to link data sources. If you send the files to someone else, their computer directory will be different, breaking the absolute path link.

Can I use relative paths for Word mail merge data sources?

Word natively uses absolute paths for mail merge connections. While there are advanced workarounds using specific field codes (like setting a DATABASE field), the standard and most reliable method is to simply re-link the file upon opening.

How do I know which Excel sheet my mail merge is connected to?

Go to the 'Mailings' tab and click 'Edit Recipient List'. If a data source is successfully connected, it will display the data source name at the bottom of the window and allow you to view the currently linked sheet's records.

Document & File Issues