Guides
Step-by-step guides for PDF mail merge, form filling, email campaigns, and more.
How to Fill PDF Forms from Excel
Step-by-step guide to bulk-filling PDF form fields with data from Excel or CSV. Upload, auto-map columns, and generate completed documents.
How to Mail Merge from Google Sheets
Connect Google Sheets to your PDF template for live data mail merge. No downloads needed — import directly from your Google account.
How to Add QR Codes to Merged PDFs
Embed dynamic QR codes into your merged PDFs using spreadsheet data. Generate unique QR codes for URLs, product IDs, tickets, and verification.
How to Send Merged PDFs via Email
Configure SMTP settings, set up email templates, and run bulk email campaigns. Send personalized PDFs as attachments to hundreds of recipients.
How to Password-Protect Merged PDFs
Encrypt your merged PDFs with unique passwords per recipient. Use spreadsheet data to generate per-row password protection for sensitive documents.
How to Mail Merge Labels from Excel
Create address labels, shipping labels, and name badges from Excel data. Design a label template, map spreadsheet columns, and bulk-generate printable labels.
How to Add Dynamic Images to Merged PDFs
Insert dynamic images into merged PDFs. Upload images to Media Albums, map filenames to spreadsheet data, and generate PDFs with personalized images.
How to Create Bulk Invoices from Excel
Generate invoices in bulk from an Excel spreadsheet. Upload your invoice template, map client data fields, and produce hundreds of invoices at once.
How to Generate Barcodes on PDF Documents
Add barcodes to merged PDFs using spreadsheet data. Generate Code 128, EAN-13, UPC-A, and other types for shipping labels and inventory documents.
How to Use Custom Fonts in PDF Mail Merge
Upload and apply custom fonts to your PDF mail merge fields. Support for CJK characters, Arabic, Cyrillic, and any .ttf, .otf, .woff, or .woff2 font file.
How to Automate PDF Generation with the REST API
Trigger PDF mail merge jobs programmatically using the Mergram REST API. Authenticate with API keys, send merge requests, and download generated PDFs.
How to Mail Merge PDFs from CSV Files
Use CSV or TSV files as your data source for PDF mail merge. Import comma-separated, semicolon-separated, or tab-separated data for personalized documents.
How to Bulk Generate Certificates
Mass-generate certificates from a spreadsheet. Upload your certificate design, place name and date fields, and produce hundreds of certificates in one batch.
How to Mail Merge Envelopes
Create and print personalized envelopes using mail merge. Design an envelope template, connect your address spreadsheet, and generate print-ready envelope PDFs.
How to Create Bulk Contracts from a Spreadsheet
Generate personalized contracts and agreements in bulk from spreadsheet data. Add per-document password protection for sensitive legal content.
How to Generate PDFs from Google Forms
Automatically generate personalized PDFs from Google Forms submissions. Connect Forms to Sheets, then trigger mail merge via API or Zapier.
How to Add Page Numbers to PDFs
Add page numbers to any PDF document. Choose position, format, font, and starting number. Free browser-based tool — no upload, no signup required.
How to Create Mail Merge Postcards
Design and bulk-generate personalized postcards with mail merge. Upload your postcard design, connect recipient data, and produce print-ready PDFs.
How to Compress PDF Files
Reduce PDF file size with a free browser-based compressor. Choose quality level and download a smaller file — no upload, no signup, works offline.
How to Merge and Split PDF Files
Combine multiple PDFs into one document or split a PDF into separate pages. Free browser-based tool — no upload to server, no signup required.
How to Convert Images to PDF
Convert JPG, PNG, and WebP images to PDF documents. Combine multiple images into one PDF with custom page size and orientation — free, in your browser.
How to Fill Out PDF Forms Online
Fill out PDF forms online for free. Upload a fillable PDF, type into form fields, and download the completed document — no signup, works in your browser.
How to Bulk Generate Designs from a Canva Template
Learn how to mail merge Canva templates — import any Canva design, connect a spreadsheet, and bulk-generate personalized certificates, invitations, ID cards, and more as PDFs.
How to Switch from Word Mail Merge to PDF
Migrate your Microsoft Word mail merge workflows to PDF mail merge. Better formatting, dynamic images, QR codes, barcodes, and email delivery — no Word required.
How to Mail Merge from a Word Template
Convert your existing Word mail merge templates into PDF templates and generate personalized documents with data from Excel or CSV. Step-by-step migration guide.
Mail Merge vs PDF Mail Merge — What's the Difference?
Understand the difference between traditional mail merge (Word documents) and PDF mail merge. Which approach is right for invoices, certificates, contracts, and bulk document generation?
How to Use Conditional Fields in PDFs
Show or hide text, images, barcodes, and QR codes dynamically in your merged PDFs. Learn conditional field visibility with practical examples for certificates, invoices, and badges.
How to Create Bulk Pay Stubs
Generate pay stubs in bulk from a spreadsheet. Upload your pay stub template, map employee data fields, and produce hundreds of personalized pay stubs at once.
How to Create Bulk ID Cards
Generate employee ID cards, student badges, and event credentials in bulk. Upload a badge template, add photos from a spreadsheet, and produce hundreds of personalized ID cards at once.
Ready to get started?
Try Mergram free — upload a PDF and spreadsheet, merge in minutes. No credit card required.