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.
Mail Merge Labels from Excel — Address & Shipping
Bulk-generate address, shipping, and name-badge labels from Excel or CSV. Map your columns once and download print-ready label sheets as PDFs. Free to start.
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.
Bulk Invoices from Excel — Free Online Generator
Turn one invoice template plus your Excel list into hundreds of numbered, personalized PDF invoices in a single click. Free to start, no signup required.
How to Add Barcodes to PDF — Free PDF Barcode Generator
Add barcodes to PDF documents from spreadsheet data. Generate Code 128, EAN-13, UPC-A, and more for shipping labels, inventory tags, and product IDs. Free online PDF barcode generator.
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 for Events & Courses
Create hundreds of personalized certificates for events, courses, and training programs in one batch — upload your design, connect a spreadsheet, download PDFs.
Mail Merge Envelopes from Excel — Free & Print-Ready
Print personalized envelopes straight from your Excel or CSV address list — #10, DL, and C5 sizes supported. Free to start, no signup required.
Bulk Contracts from a Spreadsheet — Free Generator
Generate hundreds of personalized contracts and agreements from Excel or CSV — with per-document password protection for sensitive terms. Free to start.
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 a PDF — Free, No Upload
Number PDF pages online in under a minute — paginate as 1 of N or Page 1, skip the cover, pick position and font. Free, runs in your browser, no signup.
Marketing Mail Merge: CSV to Print-Ready Postcards
Mail merge postcards from a CSV or Excel list — one print-ready PDF per customer with name, offer code, photo, and a personal QR code. Free to start.
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.
PDF Merger & Splitter — Merge and Split PDFs Free
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.
Canva Mail Merge — Bulk Create a PDF for Every Row
Mail merge any Canva design with Excel, CSV, or Google Sheets — one named PDF per row for certificates, invitations, and ID cards. No Canva Pro needed.
Switch from Word Mail Merge to PDF — Free Tool
Move off Word mail merges: keep your spreadsheet, get pixel-perfect PDFs with images, QR codes, barcodes, and per-document passwords. Free to start.
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.
Bulk Pay Stubs from Excel — Free Online Generator
Create hundreds of personalized pay stubs from your spreadsheet in one batch — upload your template, map employee fields, download the PDFs. Free to start.
Bulk ID Cards with Photos — Free Online Generator
Generate employee ID cards, student badges, and event credentials in bulk, with photos pulled straight from your spreadsheet. Free to start, no signup.
How to Add Bates Numbers to PDFs — Free, Multiple Files
Bates number one PDF or a whole production in your browser: set a prefix and digits, number across files in order, and download a ZIP with a CSV index. Free, no upload.
How to Add Exhibit Stickers to PDFs — Exhibit A, B, C, Free
Stamp an exhibit sticker on page 1 of each PDF — Exhibit A, B, C or 1, 2, 3, with an optional case number, witness and date. Free, runs in your browser, downloads a ZIP.
Ready to get started?
Try Mergram free — upload a PDF and spreadsheet, merge in minutes. No credit card required.