Office for Mac Issues

How to Create Separate Word Mail Merge Documents on Mac

Maira Mehtab Sep 21, 2026 869 views

Question details

The user wants to split a mail merge in Word for Mac so that each Excel record is saved as an individual Word document rather than one continuous file.

Product: Microsoft Word for Mac
Device & OS: macOS
Scenario: Performing a mail merge on a Mac to generate individual documents, such as certificates or customized letters, for each entry in an Excel data source.
Observed behavior: Selecting 'Edit Individual Documents' successfully populates the template but merges all records into a single continuous document instead of producing separate files for each record.

Before you start

Ensure your Excel data source is correctly formatted with clear column headers and that your Word template is fully finalized before attempting to separate the merged files.

Solution 1

Use Edit Individual Documents to Generate a Master File

Use the default Mac feature to generate a single document containing all merged records, which you can then manually save or print.

Complete Mail Merge Setup

Connect your Excel list to your Word document and insert the necessary merge fields.

Navigate to Finish & Merge

Go to the 'Mailings' tab on the ribbon and click on 'Finish & Merge'.

Generate the Master Document

Select 'Edit Individual Documents'. This creates a new, continuous document containing all your merged records, which you can then manually split or print.

Solution 2Recommended

Use a VBA Macro to Split the Merged Document

Since Word for Mac lacks a native file-splitting feature for mail merge, you can use a Mac-compatible VBA macro to automate saving each section as a separate document.

Free Microsoft Office alternative

Try WPS Office for Your Document Needs

If handling complex macros and workarounds in Microsoft Word for Mac is frustrating, try WPS Office. It provides a lightweight, highly compatible alternative with an intuitive interface for all your daily document processing tasks.

1. Download the Installer: Visit the official WPS Office website and download the Mac version.
2. Install WPS Office: Follow the on-screen instructions to quickly install the application on your macOS device.
3. Open Your Files: Open your existing .docx and .xlsx files directly in WPS Office to continue your work seamlessly.

Free and lightweight office suite optimized for MacSeamlessly compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsUser-friendly interface requiring no steep learning curveBuilt-in PDF tools for easy document distribution and saving

microsoft office alternative - wps office

Frequently Asked Questions

Why does Edit Individual Documents create just one file?

This is the default and intended behavior in Microsoft Word for Mac. It compiles all merged records into a single continuous document separated by section breaks, allowing for easy mass review and printing rather than generating hundreds of loose files.

Can I use Windows VBA macros to split my documents on a Mac?

Generally, no. Windows macros often rely on file directory paths (using backslashes) and system commands that are incompatible with macOS. You must find and use a macro specifically formatted for Word for Mac.

Is there a built-in way to email separate merged documents on Mac?

Yes, you can use the 'Merge to E-Mail' option in the Finish & Merge menu. This bypasses the need to save separate files on your drive by sending each merged record directly as an individual email via Outlook.

How do I save my merged Word document as individual PDFs?

Without a custom macro, you need to generate the continuous merged document first. Then, you can use the Mac print dialog (Command + P) and choose 'Save as PDF' while specifying the page range for each individual record.

Office App Problems