Use Multiple Email Addresses in an Excel and Outlook Mail Merge
Question details
The user wants to send a mail merge message to multiple email addresses associated with each Excel row.

- 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.
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.
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.
In Excel, add a column named Recipients next to your existing email columns.
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.
Copy the helper column, then use Home > Paste > Paste Special > Values. Save and close the workbook before connecting it to Word.
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.
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.

Use one spreadsheet row per recipient
Use this approach when a combined recipient field is not accepted or each person should receive a separate message.
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.

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.




