Fix Word Mail Merge with Multiple Email Addresses on Mac
Question details
Users experience failures when executing a mail merge in Word for Mac if an Excel data source cell contains multiple email addresses separated by semicolons.

- Product
- Microsoft Word for Mac, Microsoft Excel for Mac
- Device & OS
- Mac
- Scenario
- Attempting to send a mail merge to multiple recipients per record using semicolon-separated email addresses in a single Excel cell.
- Observed behavior
- The mail merge fails to send, and the generated messages remain stuck in the Drafts folder. Merges with single recipients process correctly.
Ensure that your Mac Outlook app is set to work offline temporarily to prevent accidental sending while testing, and verify that your Excel data source contains validly formatted email addresses.
Separate Recipients into Individual Excel Records
The most reliable workaround for this known Mac issue is to restructure your Excel data so that each email address occupies its own row.
Because Word for Mac currently struggles with parsing multiple semicolon-separated emails in a single cell during a mail merge, splitting the data ensures each recipient is processed as an individual, successful merge record.
Launch Microsoft Excel for Mac and open the workbook that contains your mail merge mailing list.
Find any rows where the email cell contains multiple semicolon-separated addresses. Insert a new row below it and copy the data over.
Edit the email column so that each row contains only one single email address. Delete the extra addresses and semicolons from each corresponding cell.
Save your Excel workbook, open your Word mail merge document, reconnect the data source if necessary, and execute the mail merge again.

Use an Excel and Outlook VBA Script
If you cannot modify your source data, use a custom VBA macro to bypass Word entirely and send emails directly from Excel to Outlook.
Report the Bug to Microsoft
Since this is a reproducible bug in versions 16.60 and later, reporting it directly to the development team helps prioritize an official patch.
Try WPS Office for a Seamless Document Experience on Mac
If you are frustrated by ongoing mail merge bugs in Microsoft Office for Mac, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for Word, Excel, and PDF workflows without the hefty subscription fees.
- 1. Download the Mac App: Visit the official WPS Office website and download the installation package designed specifically for macOS.
- 2. Install WPS Office: Open the downloaded file and drag the WPS Office icon to your Applications folder to complete the installation.
- 3. Open Your Files: Launch WPS Office and directly open your existing .docx and .xlsx files to continue working seamlessly.

Frequently Asked Questions
Can I use commas instead of semicolons for multiple emails in Word mail merge on Mac?
No, changing the delimiter to a comma will not resolve this specific bug. Word for Mac currently fails to parse multiple addresses in a single cell properly, regardless of whether you use commas or semicolons.
Why do my mail merge emails stay in the Drafts folder on Mac?
When Word for Mac encounters an unparseable email string—such as multiple addresses bundled in one cell—the internal communication with Outlook fails. As a safety mechanism, the generated messages remain stuck in your Drafts folder instead of sending.
Does this mail merge issue also happen on Windows?
This specific failure behavior is predominantly reported on Word and Excel for Mac. The Windows version of Microsoft Office generally handles semicolon-separated email addresses during a mail merge without leaving messages in the Drafts folder.
Is there a way to automate sending to multiple recipients without duplicating rows?
Yes, but it requires bypassing Word's built-in mail merge. You can use an Excel VBA macro that interacts directly with the Outlook application object to generate and send emails to a list of recipients.




