PDF Mail Merge with Email Delivery

What Is PDF Mail Merge with Email Delivery?

PDF mail merge with email delivery generates personalized PDFs and sends each one as an email attachment to the corresponding recipient — all in a single job. Instead of downloading a ZIP file and manually forwarding documents, Mergram handles delivery automatically.

Connect your SMTP server, compose an email template with merge placeholders, and select the column that contains email addresses. Each row in your spreadsheet produces a personalized PDF attached to a personalized email, sent directly to the right person.

Who Uses This?

• Accounting teams — Bulk-send invoices and financial statements to clients
• HR departments — Distribute pay stubs, offer letters, and benefits summaries to employees
• Legal teams — Send signed contracts, NDAs, and compliance documents to individual parties
• Event organizers — Deliver tickets, confirmations, and personalized agendas to attendees
• Educators — Email certificates and grade reports to students
• Healthcare administrators — Send patient forms, billing statements, and test results securely

How to Set Up Email Delivery

Step 1 — Configure Your SMTP Server

Navigate to Settings → SMTP and enter your email provider’s credentials. Mergram encrypts your password with AES-256-GCM and stores it securely.

Step 2 — Design Your PDF Template

Upload your PDF template and place data fields exactly as you would for a standard merge. This template becomes the personalized attachment for each email recipient.

You can use all field types: text, QR codes, barcodes, and images. You can also enable password protection so each recipient’s PDF is encrypted with their own unique password.

Step 3 — Compose Your Email

Switch to the Email tab in the merge panel. Use the built-in rich text editor (powered by Tiptap) to compose your message:

• Subject line — Include merge placeholders for personalization (e.g., Your Invoice [[InvoiceNumber]])
• Email body — Write in rich text with bold, italic, links, and lists
• Merge placeholders — Insert [[ColumnName]] anywhere in the subject or body to personalize per recipient

Example email body:

Dear [[Name]],

Please find your invoice [[InvoiceNumber]] attached.
The total amount of [[Amount]] is due by [[DueDate]].

Thank you for your business.

Each recipient sees their own data filled in — [[Name]] becomes “Alice Chen”, [[Amount]] becomes “$1,500.00”, and so on.

Step 4 — Map the Email Column

Select which spreadsheet column contains the recipient email addresses. Mergram uses this column to determine where each personalized PDF is sent.

Make sure your spreadsheet has a dedicated column for emails. Common column names are Email, email_address, or RecipientEmail.

Step 5 — Send and Track

Click Send to start the email campaign. Background workers process the job in a queue:

• Real-time progress — Watch as each email is sent, with a live counter and progress bar
• Per-recipient status — See which emails were delivered and which failed
• Retry support — Retry failed sends without re-processing the entire job

SMTP Provider Comparison

Combining Email with Other Features

Email + Password Protection

Send encrypted PDFs via email. Each recipient gets their own PDF protected with a unique password derived from your spreadsheet data. Use a template like [[lastName]]-[[birthYear]] — the recipient knows their own last name and birth year but cannot open anyone else’s document.

This is ideal for sensitive documents like pay stubs, financial statements, and healthcare records.

Email + QR Codes

Include verification QR codes in emailed PDFs. Each certificate or document gets a unique scannable code linking to a verification page. Recipients can share the printed document, and anyone can scan to confirm authenticity.

Email + Custom Filenames

Use filename templates to name each attached PDF descriptively: Invoice_[[InvoiceNumber]]_[[ClientName]].pdf. The recipient sees a clear, professional filename instead of a generic one.

Best Practices

1. Test with a small batch first — Send 5–10 emails to yourself or a test list before running a full campaign. Verify formatting, merge fields, and attachment content.

2. Use a dedicated sender address — Send from a professional address (e.g., billing@yourcompany.com) rather than a personal Gmail. This improves deliverability.

3. Verify your email column — Scan your spreadsheet for missing or malformed email addresses before starting. Invalid addresses cause per-row failures.

4. Personalize the subject line — Include merge placeholders in the subject (e.g., Your Invoice [[InvoiceNumber]]) to improve open rates and reduce spam filtering.

5. Enable password protection for sensitive documents — Financial statements, pay stubs, and healthcare records should always be encrypted. Use a password template the recipient can derive from their own data.

6. Monitor delivery status — After sending, review the per-recipient status in the job panel. Retry any failed sends and investigate recurring failures (often caused by invalid email addresses or SMTP rate limits).

Get Started

Send your first personalized PDF email campaign in minutes. Upload a PDF template, connect a spreadsheet with email addresses, configure your SMTP server, and compose your message. Mergram handles the rest — generating and delivering each PDF automatically.

Try Mergram free — connect your SMTP server and send your first batch today.