Send & Receive Issues

Use Multiple Email Addresses in an Excel and Outlook Mail Merge

Khadija KhanKhadija Khan Nov 22, 2026 868 views

Question details

The user wants to send a mail merge message to multiple email addresses associated with each Excel row.

Use Multiple Email Addresses in an Excel and Outlook Mail Merge
Product
Microsoft Excel, Word, and Outlook
Device & OS
not provided
Scenario
A spreadsheet contains several email address fields for each mail merge record.
Observed behavior
The user wants each merged message to reach all addresses in the corresponding row.
Before you start

Check which spreadsheet columns contain the email addresses and confirm that Word is connected to the intended Outlook account. Use test addresses you control before sending to actual recipients.

Solution 1Recommended

Test a combined recipient field in your mail merge

Combine addresses in a helper column, then test whether your Word and Outlook setup accepts multiple recipients in that field.

Outlook commonly uses semicolons to separate recipients. A Word mail merge may not accept multiple addresses in one recipient field, so a successful test is essential.

1
Add a helper column

In Excel, add a column named Recipients next to your existing email columns.

2
Combine the addresses

If the addresses are in A2, B2, and C2, enter =TEXTJOIN(";",TRUE,A2:C2) in the helper column. Fill the formula down to combine nonblank addresses in each row.

3
Save the results as values

Copy the helper column, then use Home > Paste > Paste Special > Values. Save and close the workbook before connecting it to Word.

4
Run a test merge

In Word, use Mailings > Select Recipients > Use an Existing List to select the workbook. Choose Finish & Merge > Send Email Messages, select Recipients in the To field, and send a test record to addresses you control.

5
Check delivery

In Outlook, check the sent message and confirm that each test mailbox received it. If Word rejects the field or delivery fails, use a separate row for each recipient or a mail merge tool that explicitly supports multiple recipients per record.

Test a combined recipient field in your mail merge
Recipient visibility: Addresses sent together in the To field may be visible to one another. Do not use this approach when recipients must remain private.
Free Microsoft Office alternative

Prepare Mail Merge Address Lists with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open and edit Excel-compatible address lists for an easier transition between office suites; Word and Outlook mail merge recipient behavior still depends on Microsoft Office.

Organize multiple email address columns in WPS SpreadsheetsOpen and save Microsoft Excel XLSX filesWork in a familiar, easy-to-use interfaceUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

How can I combine email addresses without extra separators for blank cells?

In Excel, use =TEXTJOIN(";",TRUE,A2:C2). The TRUE argument skips empty cells, so blank address fields do not add extra semicolons.

Can I use commas instead of semicolons between Outlook recipients?

Semicolons are commonly used in Outlook. Some Outlook versions can also accept commas if the relevant Mail option is enabled, but test the actual Word mail merge because Outlook's recipient setting does not guarantee that Word will accept multiple addresses in one field.

Why should I paste the helper column as values?

Pasting values stores the combined addresses as text rather than formulas. In Excel, copy the helper column and choose Home > Paste > Paste Special > Values before saving the workbook.

What if Word does not accept several addresses in the To field?

Create one spreadsheet row per recipient and select the single Email column in Word's Finish & Merge > Send Email Messages dialog. Alternatively, use a mail merge tool that explicitly supports multiple recipients per record.