Document Editing Problems

Fix a Blank Word Mail Merge Recipient List from an Access Query

Phi Hung Vo Nov 13, 2026 869 views

Question details

The user needs a Word mail merge to display recipients from an Access select query that combines multiple tables.

Fix a Blank Word Mail Merge Recipient List from an Access Query

Product: Microsoft Word and Microsoft Access
Device & OS: not provided
Scenario: A mail merge uses a saved Access select query as its recipient data source.
Observed behavior: The recipient list is blank when the query is used, although a merge from an underlying table works.

Before you start

Locate the Access database and the saved query used by the merge. Confirm that you can open the database and that Word can access its file location.

Solution 1Recommended

Verify the Access query returns records without prompts

Use this method to determine whether the empty recipient list originates in the query.

Open the query

In Access, open the database and double-click the saved query in the Navigation Pane. Confirm that its datasheet displays the expected records.

Inspect joins and criteria

Right-click the query and select Design View or SQL View. Check table joins, field names, and criteria for conditions that could exclude the expected records.

Remove parameter prompts

In Design View or SQL View, replace parameter prompts with appropriate fixed criteria, then save a query that returns the intended records without user input.

Test the saved query

Run the saved query again in Access and confirm that it returns recipients before reconnecting it in Word.

Verify the Access query returns records without prompts

Check the query independently: A successful merge from an underlying table does not confirm that a multi-table query returns the same records.

Solution 2

Reconnect the saved Access query in Word

Use this method if the query returns records in Access but the Word recipient list is still blank.

Free Microsoft Office alternative

Edit Word Documents with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility, making it easy to move existing documents into your workflow. It does not repair the Word-to-Access query connection.

Open and edit Microsoft Word DOC and DOCX filesWork with documents in a familiar, easy-to-use interfaceUse a free, lightweight office suiteContinue editing merge documents while troubleshooting the Word and Access connection separately

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access table work as a mail merge source but the query does not?

A multi-table query may have joins or criteria that exclude records, or it may require a parameter prompt. Open the query directly in Access and check its results and design.

How do I check whether an Access query returns recipients?

Open the database in Access and double-click the saved query in the Navigation Pane. Its datasheet should display the records you want to merge.

Can a parameter prompt cause a blank recipient list?

A query that requires a prompt may not provide a usable recordset through the Word connection. Replace the prompt with appropriate fixed criteria, save the query, and test it in Access.

Where can I check filters on the Word recipient list?

In the merge document, select Mailings > Edit Recipient List. Review and clear any filters that exclude the intended recipients.

Document & File Issues