Document Editing Problems

How to Connect an Excel Address List to Word Mail Merge Labels

Olivia Miller Sep 27, 2026 869 views

Question details

The user is unable to access or connect an Excel address list when attempting to create mail-merge labels in Word.

How to Connect an Excel Address List to Word Mail Merge Labels

Product: Microsoft Word
Device & OS: not provided
Scenario: Creating mail-merge labels using an existing address list stored in an Excel workbook.
Observed behavior: Word version 16.92 fails to access or properly recognize the Excel address list during the recipient selection step.

Before you start

Ensure your Excel workbook contains clear column headers in the first row and that the file is completely closed before initiating the mail merge process in Word.

Solution 1Recommended

Connect the Excel List via the Mailings Tab

Use the built-in Select Recipients feature on the Mailings ribbon to correctly locate and bind your Excel address list to your label document.

Often, connectivity issues happen if the wrong data source option is chosen. Following the standard Mailings ribbon sequence ensures Word applies the correct data connector for your Excel file.

Open Mail Merge Labels

Open your Word document, navigate to the 'Mailings' tab on the top ribbon, click 'Start Mail Merge', and select 'Labels...' to define your label dimensions.

Select Recipients

Still on the 'Mailings' tab, click on 'Select Recipients' and choose 'Use an Existing List...' from the drop-down menu.

Browse for Your Excel File

A file explorer window will open. Navigate to the folder where your address list is saved, select the Excel workbook, and click 'Open'.

Choose the Correct Worksheet

A 'Select Table' dialog box will appear. Click on the specific worksheet that contains your addresses, ensure the box for 'First row of data contains column headers' is checked, and click 'OK'.

Connect the Excel List via the Mailings Tab

Connection Successful: Once connected, the 'Insert Merge Field' button will become active, allowing you to add your Excel columns (like Name, Address) to your labels.

Solution 2

Convert the Excel File Format

If Word cannot read the file, saving the Excel list as a newer .xlsx format or a standard CSV file resolves compatibility blocks.

Seamless Mail Merge

Create Mail Merge Labels Easily with WPS Office

WPS Writer offers a seamless and highly compatible Mail Merge feature that connects instantly to WPS Spreadsheet or Microsoft Excel files, allowing you to generate professional labels without connection errors.

1. Open WPS Writer: Create a new document in WPS Writer and navigate to the 'Mailings' tab on the top ribbon.
2. Open Data Source: Click 'Open Data Source', browse your computer to select your Excel (.xlsx or .xls) address list, and click 'Open'.
3. Insert Merge Fields: Click 'Insert Merge Field' to seamlessly drop your spreadsheet column headers (like Name, Street, Zip Code) into the document layout.
4. Generate Labels: Click 'Merge to New Document' to finalize your data and instantly generate all your printable labels.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsIntuitive step-by-step Mail Merge wizardCompletely free and lightweight Office suite alternativeSeamless integration between documents and spreadsheets

microsoft office alternative - wps office

Frequently Asked Questions

Why is Word not recognizing my Excel spreadsheet during a mail merge?

This usually happens if the Excel file is currently open in the background, saved in an outdated or unsupported format, or if the data isn't formatted as a standard table with clear header rows.

Do I need to format my Excel data before doing a mail merge?

Yes. Ensure your data is consolidated on a single worksheet, has clear column headers in the very first row (e.g., First Name, Last Name, Address), and contains no blank rows or titles above the headers.

How can I fix the 'Data source not found' error during mail merge?

You can resolve this by reconnecting the data source. Go to the Mailings tab, click 'Select Recipients', choose 'Use an Existing List', and manually browse to select your updated Excel file.

Can I filter which addresses are printed on the labels?

Yes. Once your Excel list is successfully connected, click 'Edit Recipient List' on the Mailings tab. You can use this dialog box to filter out specific cities, sort alphabetically, or uncheck individual addresses you do not wish to print.

Document & File Issues