Document Editing Problems

How to Fix Access Recipient List Not Populating in Publisher Mail Merge

Adam Davis Oct 9, 2026 870 views

Question details

The user needs to resolve an issue where an existing address field in a Microsoft Publisher envelope or document no longer automatically fills with recipient data from a connected Microsoft Access database.

How to Fix Access Recipient List Not Populating in Publisher Mail Merge

Product: Microsoft Publisher and Microsoft Access
Device & OS: not provided
Scenario: Performing a mail merge to generate envelopes or customized documents using a database of recipients.
Observed behavior: The recipient addresses from the Microsoft Access database do not automatically merge or populate into the existing address block field in the Publisher layout.

Before you start

Ensure that your Microsoft Access database (.accdb) is fully closed and not being actively edited by another user, as locked database files can prevent Publisher from successfully retrieving recipient data.

Solution 1Recommended

Delete and Recreate the Merge Field

Remove the unresponsive address block and insert a fresh merge field to successfully re-establish the data connection with your Access database.

When an older Publisher file is reopened or moved, the existing merge fields can sometimes lose their internal linking parameters to the data source. Recreating the field forces Publisher to refresh the data connection.

Delete the unresponsive field

Open your Microsoft Publisher envelope or document, click to select the existing address field that is failing to populate, and press the Delete key to remove it entirely.

Reconnect the data source

Navigate to the 'Mailings' tab on the ribbon, click 'Select Recipients', choose 'Use an Existing List', and browse to select your Microsoft Access database (.accdb) file.

Insert a new merge field

Still in the 'Mailings' tab, click on 'Insert Merge Field'. Select the specific fields you need (such as First Name, Last Name, and Address) and place them where you want the addresses to appear.

Preview the mail merge

Click the 'Preview Results' button in the Mailings tab to verify that the recipient addresses from your Access database now populate correctly in the new fields.

Verification Tip: Use the left and right arrow buttons next to 'Preview Results' to flip through several different recipients and ensure formatting remains consistent across various address lengths.

Free Microsoft Office alternative

Simplify Your Document Mail Merges with WPS Office

While Microsoft Publisher and Access are used for heavy-duty publishing and database management, they can be complex and expensive. For everyday document creation, envelopes, and form letters, WPS Office offers a free, lightweight, and highly compatible alternative. You can easily perform seamless Mail Merges using WPS Writer and WPS Spreadsheet.

1. Prepare your data: Open WPS Spreadsheet and organize your recipient list with clear column headers (e.g., Name, Address, City), then save it as an .xlsx file.
2. Set up your document: Open WPS Writer, draft your letter or envelope layout, and navigate to the 'References' tab to locate the Mail Merge tools.
3. Connect and merge: Click 'Open Data Source', select your saved spreadsheet, insert your merge fields into the document, and click 'Merge to New Document' to generate your files.

Completely free, lightweight, and incredibly fast to installHighly compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsIntuitive Mail Merge functionality within WPS Writer that is easy to masterFamiliar user interface with zero learning curve for Microsoft Office users

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Publisher mail merge fields suddenly stop working?

Mail merge fields often break if the source database file (like an Access .accdb file) is moved to a new folder, renamed, or updated with structural column changes. Publisher loses the exact filepath or column reference, requiring you to delete and re-insert the fields to establish a fresh connection.

Can I use an Excel spreadsheet instead of an Access database for a Publisher mail merge?

Yes. If Access is causing connection issues, you can export your recipient table to Excel. In Publisher's 'Mailings' tab, click 'Select Recipients', choose 'Use an Existing List', and simply select your Excel (.xlsx) file as the data source instead.

How do I fix formatting issues in my merged address block?

Instead of relying on the default 'Address Block' feature which automatically formats the text, manually insert individual fields using the 'Insert Merge Field' button. Place fields like First Name, Last Name, and Street Address exactly where you want them, adding manual spaces or line breaks (Enter) between them for precise layout control.

Document & File Issues