Send & Receive Issues

Send Mail Merge Emails with Different Recipient Data in Microsoft Word

Algirdas JasaitisAlgirdas Jasaitis Nov 13, 2026 868 views

Question details

The user wants to send multiple mail merge emails, with each message containing data specific to its recipient.

Send Mail Merge Emails with Different Recipient Data in Microsoft Word
Product
Microsoft Word mail merge with a compatible email application
Device & OS
not provided
Scenario
Create a shared email template and populate it with different names, account details, or other fields for each recipient.
Observed behavior
Each recipient should receive an individual email containing the personalized values from their corresponding data-source record.
Before you start

Prepare a recipient list with one row per recipient and separate columns for the email address and each personalized value. Use desktop Microsoft Word with a configured, compatible email application; on Windows, classic Outlook is commonly used for this workflow.

Solution 1Recommended

Send personalized emails using Microsoft Word mail merge

Use this workflow when all recipients share the same message layout but need different values inserted into the email body.

Mail merge matches each message to one record in the connected data source. Every merge field in the template is replaced with the value from that record.

The standard Send Email Messages dialog uses one subject line and message format for the selected records. Personalizing the body does not automatically personalize the subject.

1
Create the recipient data source

Open Excel and create a table with headers such as Email, FirstName, and AccountNumber. Enter one recipient per row, fill in their personalized values, and save the workbook.

2
Start the email merge in Word

Open your message document in desktop Microsoft Word and select Mailings > Start Mail Merge > E-mail Messages. If you already have a Letters-type merge document, you can reuse its connected data source and inserted fields.

3
Connect the recipient list

Select Mailings > Select Recipients > Use an Existing List, open the saved workbook, and choose the worksheet containing your recipient table. Use Edit Recipient List to select or filter the records to include.

4
Insert personalized fields

Write the shared message text. Place the cursor where a recipient-specific value should appear, then select Mailings > Insert Merge Field and choose the corresponding column, such as FirstName or AccountNumber. Repeat for each personalized value.

5
Preview each recipient's message

Select Mailings > Preview Results and use the next and previous record arrows to inspect several messages. Check that names, email addresses, and personalized values belong to the same recipient.

6
Set the email options and send

Select Mailings > Finish & Merge > Send Email Messages. In the To box, choose your email-address column. Enter the subject line, select the mail format, and choose the records to send. Select OK to pass the messages to the configured email application.

Send personalized emails using Microsoft Word mail merge
Test the merge before sending the full list: Include a test record using your own email address, then select only that record in the Send Email Messages dialog. Confirm the received message contains the expected data before sending to all recipients.
Free Microsoft Office alternative

Prepare recipient data and email templates with WPS Office

WPS Office is a free, lightweight alternative for preparing recipient spreadsheets and editing message templates. Its familiar interface and Microsoft Office format compatibility make migration straightforward. It does not fix Microsoft Word or Outlook mail merge sending issues; use a supported Word and email-client setup for the sending workflow described here.

Organize email addresses and personalized recipient values in WPS Spreadsheets.Open and edit Microsoft Excel .xlsx recipient lists and Microsoft Word .docx templates.Use familiar spreadsheet and document-editing controls to make switching easier.Prepare your files in a lightweight office suite with free core editing tools.
microsoft office alternative - wps office

Frequently Asked Questions

How does Word put different information into each email?

Word takes values from one data-source record at a time. Select Mailings > Insert Merge Field to add columns such as FirstName or AccountNumber to the message, then use Preview Results to check how those values change between recipients.

Which column should I choose in the To box?

In Mailings > Finish & Merge > Send Email Messages, choose the column containing each recipient's email address, such as Email. Each selected record needs a valid address in that column.

Can I use a different subject line for every recipient?

The standard Word Send Email Messages dialog applies one subject line to the selected records and does not provide a merge-field selector for the subject. For different subjects, send separate filtered batches with different subject lines or use a tool that explicitly supports personalized subjects.

Why does Word not send the merged emails?

Check that a compatible email application is installed and has a working account. On Windows, open classic Outlook and confirm you can send a normal email, then check the default email-app settings. New Outlook does not support this classic Word mail merge workflow; use classic Outlook for it.

Can I send a test message without emailing everyone?

Yes. Add a record with your own email address, then go to Mailings > Finish & Merge > Send Email Messages and select that record using the Current record or From/To range option. Check the delivered email before sending the remaining records.