Document Editing Problems

Fix Word Mail Merge When an Access Data Source Cannot Be Found

Amos GikundaAmos Gikunda Nov 20, 2026 868 views

Question details

Reconnect a Word mail-merge document to an Access query when Word cannot find its data source.

Fix Word Mail Merge When an Access Data Source Cannot Be Found
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the recipient source

Open the merge document in Word, then select Mailings > Select Recipients > Use an Existing List.

2
Choose the Access database

Browse to the correct Access database file, select it, and choose Open.

3
Select the query

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.

4
Check the recipients

Select Mailings > Edit Recipient List or Preview Results to confirm that Word displays the expected records and merge fields.

Reconnect the Word document to the Access query
If the query is not listed: Open the database in Access and confirm that the query is saved and available to the affected user. Check the database location and permissions; the available queries can also depend on the connection method Word uses.
Free Microsoft Office alternative

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.

Open and edit Microsoft Word DOCX documentsWork with Microsoft Excel XLSX spreadsheetsUse a familiar interface to make moving from Office easierPrepare and edit documents in a lightweight application
microsoft office alternative - wps office

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.