Document Editing Problems

How to Select Excel Recipients for a Word Email Mail Merge

Maira Mehtab Sep 22, 2026 869 views

Question details

The user wants to know how to connect an Excel spreadsheet to a Word document to use as a recipient list for an email mail merge.

Word mail merge labels with Excel fields and Update Labels

Product: Microsoft Word
Device & OS: not provided
Scenario: Setting up a bulk email mail merge in Word using a prepared list of contacts from an Excel workbook.
Observed behavior: The user needs to successfully select the Excel file in Word and send personalized bulk emails via a MAPI-capable client like Outlook.

Before you start

Ensure your Excel spreadsheet is properly formatted with clear column headers (e.g., Email, First Name, Last Name) in the first row, and that you have a MAPI-capable email client like classic Outlook set as your default email program.

Solution 1Recommended

Select Excel Recipients for Mail Merge in Word

Use the Mailings tab in Word to locate and link your prepared Excel workbook, enabling you to send personalized mass emails.

Before linking the file, make sure your Excel data is organized correctly, has no blank rows at the top, and is closed. Word cannot link to an Excel file that is currently open.

Keep in mind that sending bulk emails directly from Microsoft Word requires a MAPI-compatible email client. You must use the classic Outlook desktop application, as the 'New Outlook' toggle does not fully support this functionality.

Start the Mail Merge

Open your Microsoft Word document. Navigate to the 'Mailings' tab on the top ribbon, click 'Start Mail Merge', and select 'Email Messages' from the dropdown list.

Choose to Use an Existing List

Still on the 'Mailings' tab, click 'Select Recipients', then choose 'Use an Existing List' to prompt the file explorer.

Locate the Excel Spreadsheet

In the file explorer window, browse your computer to find where your Excel workbook is saved. Click on the file to highlight it, then click 'Open'.

Select the Correct Table

A 'Select Table' dialog box will appear. Choose the specific worksheet that contains your recipient list. Ensure the box for 'First row of data contains column headers' is checked, and click 'OK'.

Merge and Send

Use the 'Insert Merge Field' option to add your personalized data. Once ready, click 'Finish & Merge', choose 'Send Email Messages', and ensure classic Outlook is open to process the outgoing emails.

Email Client Requirement: If your emails are not sending, verify that classic Outlook is open and set as your default email app. The 'New Outlook' application lacks the required MAPI integration needed for Word email merges.

WPS Office Alternative

Easily Perform Mail Merges with WPS Office

If you need a straightforward way to generate bulk documents or connect spreadsheets to your text files, WPS Office provides a robust, built-in Mail Merge feature that seamlessly integrates WPS Writer and WPS Spreadsheets.

1. Open WPS Writer: Launch WPS Writer and open the document you want to use as your main mail merge template.
2. Access the Mail Merge Tab: Navigate to the 'Mail Merge' tab on the top ribbon menu to access the data integration tools.
3. Open Data Source: Click 'Open Data Source', select your prepared Excel or WPS Spreadsheet (.xlsx) file, and choose the correct worksheet.
4. Insert Fields and Merge: Use 'Insert Merge Field' to place data into your document, then click 'Merge to Different New Document' to generate your customized files.

Fully compatible with Microsoft Word (.docx) and Microsoft Excel (.xlsx) formats.Intuitive Mail Merge wizard makes connecting data sources completely effortless.Lightweight software design ensures smooth performance on nearly all devices.Free to download, offering a comprehensive suite for everyday document editing needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why is 'Use an Existing List' grayed out in Word?

This option is typically grayed out if you haven't initiated the mail merge process. Go to the 'Mailings' tab, click 'Start Mail Merge', and select a document type (like 'Email Messages' or 'Letters') to activate the recipient selection options.

Can I use the New Outlook for a Word email mail merge?

No, the New Outlook application does not currently support the MAPI protocol required by Word for email mail merges. You must use the classic Outlook desktop client to send your merged emails.

How do I filter out specific Excel recipients in Word?

After linking your Excel list, click 'Edit Recipient List' in the 'Mailings' tab. In the dialog box that appears, you can uncheck individual recipients or use the 'Filter' tool to exclude specific data rows.

Why are my dates or numbers formatting incorrectly after the merge?

Word often reads raw data from Excel, ignoring visual formatting. To fix this, you can format your number and date columns in Excel as 'Text' before linking the file, or use specific formatting switches inside your Word merge fields.

Document & File Issues