Document Editing Problems

How to Refresh Word Mail Merge Recipient List from Access

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to update their Word mail-merge recipient list because recent changes and new records added to the linked Microsoft Access database are not displaying.

Product: Microsoft Word / Microsoft Access
Device & OS: not provided
Scenario: Generating a mail merge document in Word using a Microsoft Access database as the primary data source.
Observed behavior: Changes made to the recipient information in the Access database fail to automatically appear in the connected Word mail-merge recipient list.

Before you start

Ensure that your Microsoft Access database file is completely saved and closed to prevent data locking issues before you attempt to refresh the connection in Word.

Solution 1Recommended

Reconnect and Refresh the Access Data Source

Manually refreshing the data source connection in Word forces the application to fetch the most recent data from your Access database.

Microsoft Word does not continuously monitor connected databases for live changes. When you update your Access database while the Word document is open, or if the connection becomes stale, you must manually command Word to pull the latest information.

Open the Edit Recipient List Dialog

Navigate to the 'Mailings' tab on the Word ribbon. In the 'Start Mail Merge' group, click on 'Edit Recipient List'.

Refresh the Data Source

In the Mail Merge Recipients window, look at the bottom-left corner under the 'Data sources' box. Select your Access database file from the list, then click the 'Refresh' button.

Verify Updated Records

Scroll through the recipient list above to confirm that your newly added or modified Access records now appear. Make sure they are checked so they are included in the merge.

Re-establish Connection (If Refresh Fails)

If the records still do not update, close the dialog box. Click 'Select Recipients' on the Mailings tab, choose 'Use an Existing List', and browse your computer to select and open your Access database file again.

Check Your Filters: Ensure that Word is using the correct database table or query. If you previously applied filters in the Mail Merge Recipients window, make sure your new Access records meet those filtering criteria.

Seamless Mail Merge with WPS Office

Effortlessly Manage Mail Merge with WPS Writer and Spreadsheets

If you frequently experience database connection or refreshing issues, try using WPS Office. WPS Writer seamlessly integrates with WPS Spreadsheets for a highly stable and intuitive mail merge experience, avoiding complex database lockups.

1. Prepare Your Data: Open WPS Spreadsheets, organize your recipient list with clear column headers (e.g., Name, Address, Email), and save the workbook.
2. Start Mail Merge: Open your document in WPS Writer, navigate to the 'References' tab on the top ribbon, and click 'Mail Merge'.
3. Link and Insert Fields: Click 'Open Data Source', select your saved WPS Spreadsheet, and use the 'Insert Merge Field' button to add the data points into your document.

Stable and intuitive Mail Merge wizard that updates data reliably.Highly compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Lightweight office suite that processes large recipient lists quickly.Free to download and fully equipped for professional document editing.

Frequently Asked Questions

Why doesn't Word automatically update my mail merge list when Access changes?

Word captures a static snapshot of your Access data when the connection is initially made. To improve performance and prevent file corruption, it doesn't constantly poll the database. You must manually click 'Refresh' to fetch the latest data.

Can I edit Access records directly from Word's recipient list?

Yes. In the 'Edit Recipient List' dialog box, select your data source at the bottom and click 'Edit'. This opens a data form where you can add, delete, or modify records directly, which then saves back to the Access database.

What should I do if the 'Refresh' button is grayed out?

If the Refresh button is disabled, the link to the Access database has likely been broken or the file was moved. You will need to click 'Select Recipients' on the Mailings tab, choose 'Use an Existing List', and locate your database file again.

Does filtering or sorting in Word affect my original Access database?

No, any filtering, sorting, or unchecking of recipients in Word's Mail Merge Recipient List only applies to the current merge document. It does not alter, delete, or reorder the actual data stored in your Microsoft Access database.

Document & File Issues