What Is Mail Merge?
Mail merge is a technique for generating personalized documents in bulk from a template and a data source. It’s been a standard feature of word processors since the 1980s and remains one of the most common ways to produce large volumes of personalized documents.
The concept is simple:
- Create a template — a document with placeholder fields (e.g.,
«FirstName»,«Address») - Connect a data source — a spreadsheet with columns matching the placeholders
- Generate — the software creates one document per row, filling in each placeholder with real data
One template + 500 rows of data = 500 personalized documents.
Where mail merge is used
| Document Type | Example |
|---|---|
| Letters | Cover letters, offer letters, donation acknowledgments |
| Invoices | Client invoices with unique amounts and line items |
| Certificates | Training completion, awards, diplomas |
| Contracts | Employment agreements, NDAs, service agreements |
| Labels | Address labels, shipping labels, name badges |
| Compliance forms | Tax forms, insurance claims, regulatory filings |
| ID cards | Employee badges, event passes, student IDs |
| Reports | Personalized performance reports, statements |
The name comes from 'mail'
Mail merge was originally designed for mass-mailing letters — the “mail” in the name. Today, the technique is used for any document that needs to be personalized and produced in bulk, whether it’s mailed, emailed, or downloaded.
Traditional Mail Merge (Word)
Traditional mail merge is the workflow built into Microsoft Word. It’s been the default approach for decades.
How it works
- Create a template in Microsoft Word with merge fields
- Connect an Excel spreadsheet or Outlook contacts as the data source
- Generate merged Word documents (
.docx) - Optionally export each document to PDF — manually or with a macro
- Optionally email via Microsoft Outlook (MAPI)
Strengths
- Universally known — most office workers have used Word mail merge
- Built into Word — no additional software needed
- Flexible templates — Word’s full formatting capabilities are available
- Good for printed letters — the original use case still works well
Limitations
- Output is
.docx, not PDF — if you need PDF (most businesses do), you must convert manually - No dynamic images — cannot insert per-recipient photos or product images
- No QR codes or barcodes — not possible without third-party plugins
- Email requires Outlook — fragile, doesn’t work on shared machines or servers
- No password protection — cannot encrypt individual documents
- Layout inconsistency — the same
.docxrenders differently across machines, OS versions, and Word versions - Performance caps — becomes slow or unstable above a few thousand records
- Desktop-only — requires Microsoft Word installed on the machine
The PDF conversion problem
Most businesses need their final documents in PDF format. With Word mail merge, you generate .docx files and then convert each one to PDF — a manual, error-prone process. The conversion can introduce layout changes depending on the machine, installed fonts, and printer driver. PDF mail merge eliminates this step entirely.
PDF Mail Merge
PDF mail merge applies the same merge concept directly to PDF templates. Instead of starting in Word and converting to PDF at the end, you start with a PDF and generate PDFs.
How it works
- Design your template in any tool (Word, Canva, Google Docs, InDesign) and export as PDF
- Upload the PDF template to a PDF mail merge tool (like Mergram)
- Connect a data source — Excel, CSV, or Google Sheets
- Place fields visually — drag column headers onto the PDF pages
- Generate — each row produces a separate PDF
Strengths
- Native PDF output — no conversion step, no layout surprises
- Pixel-perfect rendering — identical output on every device and OS
- Dynamic images — insert per-recipient photos, logos, and product images
- QR codes & barcodes — built in, no plugins needed
- Email delivery — any SMTP server (Gmail, SendGrid, Amazon SES, custom)
- Per-recipient encryption — unique passwords for each document
- High volume — up to 100,000 rows per job with background processing
- Browser-based — no desktop software or Word license required
- REST API — trigger merges programmatically from external systems
When PDF mail merge is the right choice
- Your final format is PDF (invoices, certificates, contracts, compliance documents)
- You need consistent rendering across devices and recipients
- You want to embed images, QR codes, or barcodes
- You need to email the generated documents
- You need password-protected output
- You’re processing hundreds or thousands of records
Side-by-Side Comparison
| Feature | Word Mail Merge | PDF Mail Merge |
|---|---|---|
| Template format | .docx | .pdf (from any source) |
| Output format | .docx (manual PDF export) | .pdf (native) |
| Layout consistency | Varies by machine and Word version | Pixel-perfect, identical everywhere |
| Data sources | Excel, CSV, Outlook contacts | Excel, CSV, Google Sheets, REST API |
| Dynamic images | Not supported | Supported |
| QR codes | Not supported | Built-in |
| Barcodes | Requires third-party plugin | Built-in (Code 128, EAN-13, UPC-A) |
| Email delivery | Outlook + MAPI only | Any SMTP server |
| Password protection | Not supported | Per-recipient, data-derived passwords |
| Custom fonts | System fonts only | Upload any font file |
| Volume limit | ~1,000 rows (degrades above) | Up to 100,000 rows per job |
| Visual field editor | No — fields placed inline in text | Yes — drag-and-drop on PDF pages |
| Real-time preview | Limited (Next Record preview) | Full row-by-row preview in browser |
| API access | None | Full REST API with API keys |
| Software required | Microsoft Word + Outlook | Browser only |
| Cross-platform | Windows, macOS (with Office) | Any device with a browser |
| Automation | Manual, desktop-bound | REST API, Zapier, Make.com integrations |
Choosing the Right Approach
Use traditional Word mail merge when:
- You need editable output — recipients must be able to modify the document
- You’re producing printed letters and don’t need PDF
- Your team is already deep in the Microsoft ecosystem (Word + Outlook + Exchange)
- You’re working with fewer than 100 records and don’t need advanced features
Use PDF mail merge when:
- Your final format is PDF — which is the case for most business documents
- You need consistent rendering across all recipients and devices
- You want to embed images, QR codes, or barcodes
- You need to email the generated documents to recipients
- You need password protection on individual documents
- You’re processing hundreds or thousands of records
- You want to automate merges via API or integrations
Most businesses end up at PDF
If your workflow is: design in Word → merge → convert to PDF → send — you can cut out the middle step. PDF mail merge starts and ends at PDF. Your template stays pixel-perfect, and you skip the unreliable Word-to-PDF conversion.
How PDF Mail Merge Works in Practice
Let’s walk through a concrete example: generating 500 personalized invoices.
The old way (Word mail merge)
- Design invoice in Word with merge fields
- Connect Excel spreadsheet with client data
- Generate 500
.docxinvoices - Manually export each one to PDF (or write a macro)
- Manually email each PDF via Outlook
- Hope the layout survived the conversion
The new way (PDF mail merge with Mergram)
- Design invoice in any tool (Word, Canva, Google Docs) → export as one PDF
- Upload the PDF + Excel spreadsheet to Mergram
- Drag column headers onto the invoice:
ClientName,Amount,DueDate,InvoiceNumber - Preview any row in real time — rendered in your browser
- Click Merge → download 500 PDFs as ZIP, or send via email in one click
Result: 500 consistent, accurate PDF invoices in minutes — no Word dependency, no manual conversion, no layout issues.
Common Questions
”Can I still design my template in Word?”
Yes. Design in Word (or any tool), export as PDF, and upload to a PDF mail merge tool. The design step doesn’t change — only the merge and output steps change.
”What about my existing data?”
Your data doesn’t change. The same Excel, CSV, or Google Sheets files you use with Word mail merge work directly with PDF mail merge tools. Same columns, same rows, same format.
”Is PDF mail merge more expensive?”
Not necessarily. Tools like Mergram offer free trials and credit-based pricing — you only pay for what you generate. For high-volume users, the time saved on manual conversion and email handling often makes PDF mail merge cheaper overall.
”Can I automate PDF mail merge?”
Yes. Mergram provides a REST API with API key authentication. Trigger merges from Zapier, Make.com, or your own application. Automate the entire pipeline: data update → merge → email — no human intervention needed.
Try PDF Mail Merge
Experience the difference firsthand:
- Free demo — mergram.com/try — no sign-up required. Upload a sample PDF and spreadsheet, drag fields, and see merged output in seconds.
- Free account — mergram.com/new — full access to the editor, preview, and email delivery. Free credits to test with real documents.
Start with your most common template
Pick the document you generate most often — invoices, certificates, or contracts. Export it as PDF, upload to Mergram with your existing spreadsheet, and try the preview. You’ll see the difference in under two minutes.