Office for Mac Issues

Fix Word Mail Merge with Multiple Email Addresses on Mac

Steven ParkerSteven Parker Oct 28, 2026 869 views

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.

How to Fix Word Mail Merge Failing with Multiple Email Addresses on Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Open your Excel data source

Launch Microsoft Excel for Mac and open the workbook that contains your mail merge mailing list.

2
Duplicate rows for multiple emails

Find any rows where the email cell contains multiple semicolon-separated addresses. Insert a new row below it and copy the data over.

3
Isolate the email addresses

Edit the email column so that each row contains only one single email address. Delete the extra addresses and semicolons from each corresponding cell.

4
Save and rerun the merge

Save your Excel workbook, open your Word mail merge document, reconnect the data source if necessary, and execute the mail merge again.

Separate Recipients into Individual Excel Records
Single Recipients Work: Testing confirms that running the mail merge with single-recipient records processes correctly and prevents messages from getting stuck in the Drafts folder.
Free Microsoft Office alternative

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. 1. Download the Mac App: Visit the official WPS Office website and download the installation package designed specifically for macOS.
  2. 2. Install WPS Office: Open the downloaded file and drag the WPS Office icon to your Applications folder to complete the installation.
  3. 3. Open Your Files: Launch WPS Office and directly open your existing .docx and .xlsx files to continue working seamlessly.
Highly compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsRobust data management and document formatting tools without native Mac bugsLightweight application that runs smoothly on macOSFree to download and use for all essential office tasks
QA img-9

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.