Skip to main content
Mail merge software

Mail merge software, past the limits of Word + Excel.

Classic mail merge handles letters, labels, and personalised email beautifully. It starts to creak when the deliverable is a branded deck, the data lives in a CRM or warehouse, and the volume passes the point where someone is willing to run the macro by hand. This page is the honest map of when each tool is the right call — and what SourceToDocs adds when you’ve outgrown the old workflow.

What mail merge software actually is

The textbook definition is straightforward: software that takes a template and a list, walks the list row by row, and produces one personalised output per row. The template has placeholders (“Dear {{first_name}}”), the list has columns (first_name, address, balance_due), the engine stitches them together. That mechanic has been shipping in word processors since the 1980s and it still solves 80% of the personalisation problems people have.

In practice, “mail merge software” today covers three different families of tools that share the mechanic but solve different jobs. Word + Excel mail merge — the original — is still the right answer for letters, labels, certificates, and form-letter PDFs where the data already lives in a spreadsheet and the output stays inside an Office-shaped world. It’s free, it’s ubiquitous, and for the 50-recipient holiday letter it’s genuinely hard to beat.

Then there’s the Gmail and Workspace family — GMass, YAMM, Mailmeteor, and a long tail of similar extensions. These exist because Gmail itself has no native mail merge, and someone needed to send 500 personalised emails out of a Google Sheet without running afoul of the spam filters. They’re focused, well-priced, and the right call when the job is “personalised email at volume.” They’re not trying to produce branded PDFs or decks. They don’t need to.

And then there’s the third family — document automation platforms — which is what people usually end up searching for when the first two families have run out of road. The shape of the problem shifts: the deliverable is a branded artefact rather than a letter or an email, the data lives somewhere richer than a spreadsheet, and the volume or recurrence makes “run the mail merge wizard once a month” an unfun option. That’s where this page picks up.

The three tiers of mail merge software

1. Office-native — Word + Excel mail merge

The original. A Word document with merge fields, an Excel sheet with one row per recipient, the mail merge wizard joining them. It produces personalised letters, labels, envelopes, certificates, and form-letter PDFs — usually printed, occasionally PDF-exported, sometimes emailed via Outlook. The strengths are real: it’s free, it’s offline, the template lives in a file you can email a colleague, and anyone who’s used Office for ten minutes can muddle through it. For low-volume, low-design personalisation jobs, it’s still the right answer.

Right call when: the document is fundamentally a Word document, the data already lives in a spreadsheet, and the volume is something a human will happily click through once. Letters, labels, certificates, invoices for a small practice, envelopes for a wedding.

Wrong call when: the output is a branded deck or a multi-page report with charts and conditional sections, the data lives in a CRM or warehouse, or the workflow needs to repeat on a schedule without anyone touching it.

2. Gmail and Workspace mail merge tools

GMass, YAMM (Yet Another Mail Merge), Mailmeteor, and a handful of others. These exist because Gmail itself doesn’t do mail merge natively, and someone needs to send 500 personalised emails out of a Google Sheet on Tuesday morning. They typically install as a Workspace add-on or a Gmail extension, read from Sheets, and push personalised emails through Gmail (with throttling, tracking, follow-ups, and the usual deliverability scaffolding). Pricing is modest — usually $10 to $25 per user per month — and the focus is tight: outbound personalised email at small-to-medium volume.

Right call when: the deliverable is email, you live in Gmail or Workspace, and the win is tracking, follow-ups, and not getting flagged as a spammer.

Wrong call when: the deliverable is a document — a deck, a PDF, a branded report — rather than an email body. These tools aren’t trying to render brand templates with logo-perfect fidelity. That’s the next category.

3. Document automation platforms

The category SourceToDocs sits in, along with a handful of others. The shape of the problem has shifted: you’re not producing a letter or an email, you’re producing a branded artefact — a Slides deck, a multi-page PDF, eventually a Word doc or HTML report — from data that lives somewhere richer than a spreadsheet. The template is owned by a designer (or a brand team), the data is owned by an analyst or an ops lead, and the workflow needs to run repeatedly without losing the brand layer between runs.

Right call when: the document needs to look like your design team made it by hand, the data lives in a CRM, warehouse, Airtable base, or behind a custom API, and the cadence is recurring — monthly client reports, quarterly QBRs, weekly investor updates, conference programs, LP letters.

Wrong call when: the job is genuinely just letters from a list. If Word + Excel does it in twenty minutes, use Word + Excel. Document automation pays back at volume and brand complexity, not at one-off simplicity.

When you’ve outgrown classic mail merge

Three signals tend to show up together. Any one of them is survivable; all three is usually the moment to switch categories.

Signal 1: the document needs branded design beyond Word.

The internal version was a Word letter. The client-facing version needs to look like the rest of the company’s collateral — the right typeface licensed properly, the brand palette, the carefully spaced cover page, a chart that actually matches the deck style guide. Word can be coerced into looking polished, but at the point where you’re fighting Word’s rendering to get there, you’ve usually already lost the argument. The brand team has a Slides master or a PowerPoint master — that’s where the deliverable should be generated from, not Word.

Signal 2: the data lives somewhere richer than a spreadsheet.

The list of recipients is in Salesforce. The metrics come from BigQuery. The line items are in Airtable. The status updates are in Notion. Exporting all of that to a single CSV every month so the mail merge wizard can read it is a real job — one that mostly gets done at 11pm the night before the report is due, with predictable consequences. Document automation platforms read those systems natively, which removes the manual export step and the “wait, which version of the CSV did we ship?” question that comes with it.

Signal 3: the volume passes the point where automation pays back.

Rough rule of thumb: somewhere between fifty and a hundred branded deliverables a month is where the math flips. Below that, a careful operator with a good Slides template and an hour on Tuesday afternoon is genuinely cheaper than any platform. Above it, the per-document time and per-document error rate of manual production are the things eating your week. The point of document automation isn’t to do the work you could already do faster — it’s to do the work you can’t reliably do by hand at the volume you actually need.

How SourceToDocs handles bulk personalised documents

The mental model is three layers. A designer-authored master template — a Google Slides deck today, PowerPoint and Word on the roadmap — owns the brand: typography, palette, master slides, logo placement, the things that should stay the same on every run. A data source — Airtable, Google Sheets, Notion, Postgres, MySQL, Salesforce, HubSpot, Pipedrive, BigQuery, Snowflake, Redshift, or any custom REST endpoint — owns the things that should change: client name, metrics, charts, sections that appear or hide based on conditions. The engine binds them together, one artefact per row or per query result, output as Slides and PDF.

The Free plan is $0 forever and includes the full template engine and full API access — 1 project, 1 data connector, 5 generations per month, outputs carrying a small “Generated by SourceToDocs” footer. That’s usually enough to wire up one real workflow and decide whether the model fits. Paid plans (Starter $79, Pro $299, Business $899) drop the footer, expand the connectors, and lift the monthly generation count. Enterprise covers SSO/SAML, audit logs, custom retention, and dedicated CSM for organisations that need that layer.

One thing to flag honestly: today’s output formats are Google Slides and PDF. PowerPoint, Word, and HTML are on the roadmap and will roll out without a tier change — but if your recipients need a `.docx` artefact this quarter, classic Word mail merge (or a Word-native generator) is the right call, not us. If Slides and PDF are the right shape for your deliverable, we’re built for the volume, the brand fidelity, and the data binding that classic mail merge wasn’t designed around.

Get Started →

FAQ

Common questions, answered

What's the difference between mail merge software and document automation? +
Mail merge software fills a template with rows from a list — one row, one output, typically letters, labels, or personalised emails. Document automation is the broader category: the same idea, but extended to richer outputs (branded decks, multi-page PDFs, reports), richer data sources (CRMs, warehouses, Airtable, REST APIs), and richer logic (conditional sections, repeating tables, dynamic charts). For a 50-row contact list going to a Word letter, mail merge is the right shape. For a monthly client report assembled from Postgres plus Salesforce plus a designer-built Slides master, you’re in document automation territory.
Can I do mail merge from a CRM like Salesforce or HubSpot? +
Yes. SourceToDocs reads natively from Salesforce, HubSpot, and Pipedrive — alongside Airtable, Google Sheets, Notion, Postgres, MySQL, BigQuery, Snowflake, Redshift, and custom REST endpoints. The unit of work is “take this query, this view, this list, and turn it into a branded document per row.” That’s different from classic Word + Excel mail merge, which assumes the data lives in a spreadsheet you export by hand.
What output formats do you support today? +
Google Slides and PDF, on every plan including Free. PowerPoint, Word, and HTML are on the roadmap. We name this honestly because it matters in evaluation — if you need a `.docx` artefact this quarter, classic Word mail merge or a Word-native tool is the better call. If your outputs are decks or PDFs, we’re built for that.
Is there a free option? +
Yes. The Free plan is $0 forever — 1 project, 1 data connector, 5 generations per month, full template engine, full API access. Outputs carry a small “Generated by SourceToDocs” footer until you upgrade. It’s the right way to test the platform on one real workflow before committing.
How is this different from GMass, YAMM, or Mailmeteor? +
GMass, YAMM, and Mailmeteor are Gmail/Workspace mail merge tools — their job is sending personalised email at volume from a Google Sheet. They do that job well. SourceToDocs doesn’t send email. We generate the document — the deck, the PDF, the branded report — that you might then attach to email or share via link. The two categories are complementary: if your problem is “blast 500 personalised emails,” pick a Gmail mail merge tool. If your problem is “produce 50 branded client reports a month,” pick a document automation platform.
What about conditional sections and variable content? +
Supported. Sections can appear, hide, or repeat based on the data — a slide that only renders for clients above a certain tier, a table that loops over an array of line items, a chart that swaps based on the customer’s segment. That’s the kind of logic classic mail merge struggles with and where document automation pays back.
Can I do bulk personalised PDFs from Airtable or Google Sheets? +
Yes — that’s a core use case. Connect Airtable or Sheets, pick the view or query, point at a Slides master template, and SourceToDocs generates one branded artefact per row, output as Slides and PDF. You can run it manually, on a schedule, or via the API on every tier.
How does pricing compare to traditional mail merge tools? +
Word + Excel mail merge is free (you already own Office). Gmail mail merge tools sit in the $10–$25/user/month range. SourceToDocs is per-workspace: Free at $0, Starter at $79, Pro at $299, Business at $899, Enterprise custom — yearly billing saves 20%. The per-workspace model usually works out cheaper than per-seat once a small ops team is generating documents on behalf of many internal stakeholders.

Outgrown classic mail merge?

Try the Free plan, or talk to us about how recurring branded documents at scale would look on your data.

Get Started →