By the ActiveMerge team. We build document-automation software and have run thousands of Excel-to-Word merges across contracts, invoices, certificates, and proposals. This guide reflects hands-on testing of every tool below, not a feature-sheet roundup.
Short answer: For most teams, ActiveMerge is the best mail merge app for turning Excel rows into Word and PDF documents in bulk, because it covers the full job — generate, preview, deliver — with no IT setup.
Word’s built-in merge is the right free choice for one-off printed letters. Power Automate and Plumsail are better for Microsoft-centric workflows with a developer. Docupilot wins if you need conditional logic inside templates.
Mail merge is the same idea it has always been: take a list of records from Excel, drop each one into a Word template, and produce one personalized document per row. Letters, contracts, invoices, certificates, labels — anything that is the same shape but different details for every recipient.
The tools have drifted in two directions. Word’s built-in mail merge hasn’t meaningfully changed in twenty years and still can’t produce separate files or PDFs. Document-automation platforms can do far more but are priced and built for developers and IT departments. This guide compares the best options across that range, from the free built-in tool to full automation platforms.
How We Evaluated These Tools
We tested each app on the same real task: a 100-row Excel file merged into a Word contract template, output as separate PDFs, then emailed to recipients. We scored each tool against the seven criteria below — the things that actually separate a usable mail merge tool from a frustrating one.
- Separate files, not one giant document. Word’s native merge produces a single document with every record stacked on different pages. Real workflows need one file per recipient.
- PDF output. Most documents sent to clients should be PDFs, not editable Word files. A good tool produces both.
- Uses your existing Word template. You shouldn’t rebuild your letterhead or contract in a proprietary editor. Standard
.docxwith simple placeholders is the goal. - Automatic field mapping. Matching Excel columns to template placeholders by hand is tedious and error-prone. The tool should suggest the mapping.
- Preview before the batch. You want to see record #1 rendered correctly before generating 500 documents.
- Delivery. Generating the files is half the job. Emailing them — ideally from your own address with tracking — is the other half.
- Bulk download. Getting all files in one ZIP beats saving 500 attachments one at a time.
Quick Verdict
| Tool | Best for | Starting price |
|---|---|---|
| ActiveMerge ⭐ | Best overall for teams turning Excel into Word/PDF in bulk without setup | Free, then $19/mo |
| Word’s built-in Mail Merge | Best free option for one-off printed letters and labels | Free with Office |
| Mail Merge Toolkit (MAPILab) | Best for emailing a Word merge with attachments | ~$49 one-time |
| Microsoft Power Automate | Best for Microsoft-only shops with a developer | $15/user/mo + M365 |
| Docupilot | Best for conditional logic inside templates | $29/mo |
| Plumsail Documents | Best for SharePoint / Microsoft 365 developers | $29/mo |
1. ActiveMerge — Best Overall for Most Teams ⭐
Verdict: ActiveMerge is the best mail merge app for any team that regularly turns Excel rows into personalized Word or PDF documents and wants to generate, preview, and deliver them without building anything. Most users finish their first merge in under ten minutes.
ActiveMerge is purpose-built for this exact workflow: upload an Excel file, upload a Word template, and generate one personalized document per row in bulk. It covers the full job — generate, preview, deliver — without the setup the heavier platforms demand.
How it works:
- Upload your Excel (
.xlsxor.csv) data file. - Upload your existing Word template, using simple
{FirstName}style placeholders. - Review the automatically suggested field mappings.
- Preview the first document as a PDF.
- Click Generate All and download everything as a ZIP — or email it directly.
Strengths:
- Uses your real Word templates. Standard
.docxfiles with{placeholder}syntax. No Content Controls, no proprietary editor, no rebuilding documents. - Smart field matching. A 4-tier detection engine (Exact → Normalized → Pattern → Fuzzy) maps “First Name” in Excel to
{firstName}or{first_name}automatically, even when names don’t match exactly. - Word, PDF, PowerPoint, and Excel output. Keep the editable
.docx, produce a PDF, or both. It also handles.pptxand.xlsxtemplates — something almost no mail merge tool does. - Preview before the batch. See document #1 rendered before committing to the full run.
- Bulk ZIP download. All generated documents packaged into a single file.
- Built-in email campaigns. Connect your own SMTP and send each document to its recipient with open tracking and pause/resume control. No separate email tool.
- Beyond spreadsheets. Pull data natively from Google Sheets, Notion, or Airtable in addition to uploaded Excel files.
- E-signatures (add-on). Send a generated contract straight into a signing flow with a full audit trail.
- REST API + webhooks for teams that want to trigger merges programmatically.
Tradeoffs: ActiveMerge doesn’t yet support conditional logic inside templates (show/hide sections based on a data value). If that’s a hard requirement, Docupilot is the better fit.
Pricing: Free to start (25 documents, one time), then Pro $19/mo (200 docs), Plus $39/mo (750 docs), Business $89/mo (2,500 docs), Ultra $149/mo (5,000 docs).
2. Word’s Built-In Mail Merge — Best Free Option for One-Off Printed Letters
Verdict: The best free choice when you need a single batch of printed letters, labels, or envelopes and one combined document is acceptable. It falls short the moment you need separate files, per-recipient PDFs, or reliable email.
The mail merge feature built into Microsoft Word (Mailings tab → Start Mail Merge) is the baseline everyone starts with. It connects to an Excel sheet, lets you insert merge fields, and prints or emails the results.
Tradeoffs:
- No separate files. “Finish & Merge → Edit Individual Documents” produces one long document with each record on its own page — not 500 separate files. Splitting them requires a macro or a manual save-as for each.
- No per-recipient PDF. You can print to PDF, but only as one combined file.
- Email is bare-bones. “Merge to Email” sends through Outlook with no attachment support, no tracking, and frequent deliverability and formatting issues.
- No field mapping help. You insert every field by hand.
- Fragile formatting. Number and date formatting from Excel often breaks (the classic “$1,000.00 becomes 1000” problem) and requires field-code switches to fix.
Pricing: Included with any Microsoft Office / Microsoft 365 license.
3. Mail Merge Toolkit (MAPILab) — Best for Emailing a Word Merge with Attachments
Verdict: The best pick for someone committed to Word’s native merge who only needs to fix its email weaknesses — attachments, personalized subject lines, and HTML formatting.
Mail Merge Toolkit is a long-standing Word/Outlook add-in that extends the native mail merge specifically to improve email sending.
Tradeoffs:
- It enhances Word’s merge, so it inherits Word’s lack of per-recipient document generation.
- Windows/Outlook only; no web app, no API, no Mac support.
- It solves email delivery but not bulk PDF generation, previewing, or non-Word data sources.
Pricing: Roughly a $49 one-time license per user (varies by edition).
4. Microsoft Power Automate — Best for Microsoft Shops with a Developer
Verdict: The best choice for Microsoft-only organizations that need document generation as one step in a larger automated workflow and have a developer to build and maintain it. It’s genuinely capable but was never designed specifically for mail merge.
Power Automate can read rows from an Excel table and populate a Word template using the “Populate a Microsoft Word template” action, integrating with the rest of Microsoft 365.
Tradeoffs:
- Setup is a project. A reliable flow means a trigger, the Excel connector, an “Apply to each” loop, the Word template action, and a delivery step — built and maintained in the Flow editor.
- Premium connector required. The Word template action is a premium connector, billed on top of Microsoft 365.
- Content Controls, not placeholders. Templates must use Word Content Controls, a syntax most Word users have never touched.
- Files must live in OneDrive/SharePoint. Local Excel files aren’t supported.
- No preview, no bulk ZIP.
Pricing: Power Automate Premium from $15/user/month (billed annually), plus a Microsoft 365 subscription.
5. Docupilot — Best for Conditional Logic Inside Templates
Verdict: The best fit for teams whose main requirement is conditional logic — showing or hiding whole sections based on data values, like a warranty clause only for hardware or a different payment schedule per plan. This is the one area where ActiveMerge currently can’t compete.
Docupilot is a capable document-automation platform with a no-code template builder, conditional logic, and 70+ integrations.
Tradeoffs:
- Templates are built in Docupilot’s editor rather than your existing Word files (though it imports
.docx). - No image generation, no built-in email campaigns from your own SMTP, no Notion integration.
- Higher pricing at volume — mid-tier plans run $99–$149/mo for 500–1,000 documents.
Pricing: From $29/mo (100 docs); $99–$149/mo mid-tier.
Verdict: The best option for developers building document automation inside a SharePoint or Microsoft 365 environment. Powerful, but technical to set up.
Plumsail Documents supports DOCX, PPTX, Excel, and HTML/PDF templates with Mustache/Handlebars syntax and a rich connector library.
Tradeoffs:
- Built for developers and IT admins; the interface and setup are technical.
- Credit-based pricing where credits expire monthly.
- No built-in email campaigns, no image generation, no Notion.
Pricing: From $29/mo (200 docs); $79/mo (1,000 docs).
Feature Comparison
| Feature | ActiveMerge | Word Mail Merge | Power Automate | Docupilot | Plumsail |
|---|---|---|---|---|---|
| One separate file per record | ✅ | ❌ | ✅ | ✅ | ✅ |
| PDF output | ✅ | ⚠️ combined only | ✅ | ✅ | ✅ |
Uses existing .docx templates |
✅ | ✅ | ❌ Content Controls | ⚠️ import | ✅ |
| Automatic field mapping | ✅ | ❌ | ❌ | ❌ | ❌ |
| Preview before bulk run | ✅ | ❌ | ❌ | ✅ | ⚠️ |
| Bulk ZIP download | ✅ | ❌ | ❌ | ✅ | ✅ |
| Built-in email delivery | ✅ SMTP | ⚠️ Outlook only | ⚠️ connector | ❌ | ❌ |
| PowerPoint / Excel templates | ✅ | ❌ | ❌ | ❌ | ✅ |
| Notion / Airtable data | ✅ | ❌ | ❌ | ⚠️ Airtable | ❌ |
| E-signatures | ✅ add-on | ❌ | ❌ | ✅ add-on | ❌ |
| Conditional logic in templates | ❌ | ❌ | ⚠️ | ✅ | ✅ |
| No IT setup required | ✅ | ✅ | ❌ | ✅ | ❌ |
| Starting price | Free / $19 | Free w/ Office | $15/user + M365 | $29 | $29 |
How to Choose
- You just need to print a batch of letters or labels once. Word’s built-in mail merge is free and fine.
- You only need to fix Word’s email-with-attachments gap. Mail Merge Toolkit does exactly that.
- You’re a Microsoft shop with a developer and a broader workflow to automate. Power Automate or Plumsail.
- Your documents need conditional show/hide sections. Docupilot.
- You want to turn Excel into personalized Word and PDF documents in bulk, preview them, and deliver them — without building anything. ActiveMerge.
Frequently Asked Questions
What is the best mail merge app for Excel and Word in 2026?
For most teams, ActiveMerge is the best mail merge app because it turns Excel rows into separate Word or PDF files in bulk, maps fields automatically, previews before the run, and emails from your own address — with no IT setup. Word’s built-in merge remains the best free option for one-off printed letters.
Can Word’s built-in mail merge create separate PDF files for each recipient?
No. Word’s native mail merge produces a single combined document with each record on its own page. It cannot generate one separate file per recipient or one PDF per recipient without a macro or a manual save-as for each record. Dedicated tools like ActiveMerge do this in one step.
What is the best free mail merge tool?
Word’s built-in mail merge is the best free tool for a one-time batch of printed letters, envelopes, or labels where a single combined document is acceptable. ActiveMerge offers a free tier (25 documents) for teams that need separate files, PDF output, and email delivery.
How do I do a mail merge from Excel to Word and save separate files?
Upload your Excel file and Word template to a tool that supports per-record output, such as ActiveMerge: map the fields, preview document #1, then generate all records and download them as a ZIP or email them individually. Word’s native merge cannot do this directly.
Which mail merge tool supports conditional logic in templates?
Docupilot and Plumsail Documents support conditional logic (showing or hiding sections based on data values). ActiveMerge does not yet support conditional logic, so for that specific requirement Docupilot is the recommended choice.
Do any mail merge tools email the generated documents automatically?
Yes. ActiveMerge has built-in email campaigns over your own SMTP with open tracking and pause/resume. Word can email through Outlook but without attachment support or tracking, and Mail Merge Toolkit adds attachment support to a Word-based merge. Power Automate, Docupilot, and Plumsail require a separate delivery step or connector.
The Bottom Line
Word’s built-in mail merge is where everyone starts, but it stops short exactly where most real work begins: separate files, PDFs, and reliable delivery. The heavyweight automation platforms go further but ask for developer time, premium licenses, and a Microsoft-centric setup.
ActiveMerge sits in the gap that matters for most teams — as simple as Word’s mail merge to start, but it produces one polished file per record, exports PDF and ZIP, maps fields automatically, and emails results from your own address. Upload your Excel data, upload your Word template, preview, and generate. Most users are done in under ten minutes.
