Fix Word Mail Merge When an Access Data Source Cannot Be Found
Question details
Reconnect a Word mail-merge document to an Access query when Word cannot find its data source.

- Product
- Microsoft Word and Microsoft Access
- Device & OS
- not provided
- Scenario
- A shared Word mail-merge document uses an Access query as its recipient data source and works on other computers.
- Observed behavior
- Word intermittently loses the connection to the Access query, and reinstalling Office provides only a temporary fix.
Locate the Access database and confirm that the affected computer can open it and access the required saved query. If the database is shared, check that its network location is available on that computer.
Reconnect the Word document to the Access query
Use this when Word cannot find the data source but the Access database and query are available.
Open the merge document in Word, then select Mailings > Select Recipients > Use an Existing List.
Browse to the correct Access database file, select it, and choose Open.
In the data source selection dialog, choose the saved Access query used by the merge, then select OK. Choose a table only if it contains the intended recipient data.
Select Mailings > Edit Recipient List or Preview Results to confirm that Word displays the expected records and merge fields.

Reset the mail-merge document type and reconnect
Use this if reconnecting the source alone does not restore the merge.
Edit Word-Compatible Documents with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for working with existing documents and spreadsheets. It does not repair Microsoft Word's connection to an Access query.

Frequently Asked Questions
Why does the mail merge work on another computer but not mine?
The affected computer may not have the same access to the database location or query. Open the database from that computer and check its network access and permissions, then reconnect it through Mailings > Select Recipients > Use an Existing List.
What if Word asks me to select a table but my data is in a query?
After opening the Access database through Mailings > Select Recipients > Use an Existing List, look for the saved query in the selection dialog. If it is not listed, confirm in Access that the query is saved and accessible; its availability can depend on the connection method.
Do I need to reinstall Office to reconnect the data source?
Usually not. First try selecting the database and query again from Mailings > Select Recipients. If that fails, use Start Mail Merge to change the document to a normal document, then choose the merge type and reconnect.
How can I check that the correct records are connected?
In Word, select Mailings > Edit Recipient List to inspect the recipients, or choose Preview Results to see how the merge fields appear in the document.




