What Is QR Code PDF Mail Merge?
QR code PDF mail merge lets you embed dynamic, per-recipient QR codes into your merged PDF documents. Each row in your spreadsheet produces a unique QR code — different URLs, different product IDs, different verification links — all generated automatically and placed precisely on the page.
The QR codes are generated at high resolution as PNG images and embedded directly into the PDF. They scan reliably from both printed and digital documents.
Who Uses This?
- Event organizers — Unique check-in QR codes on tickets and badges for every attendee
- Certificate issuers — Verification links embedded in diplomas and completion certificates
- Product manufacturers — Item-specific QR codes for inventory, warranty registration, and product pages
- Payment processors — Per-invoice payment links that recipients can scan to pay instantly
- Marketing teams — Personalized landing page URLs on direct mail and promotional materials
- Healthcare providers — Patient-specific QR codes linking to portals, records, or prescription info
- Educators — Student-specific links to grade portals or assignment pages
How to Add QR Codes to Merged PDFs
Step 1 — Prepare Your Spreadsheet
Ensure your spreadsheet has a column with the data you want to encode as QR codes. Each cell value becomes one QR code.
Example spreadsheet:
| Name | VerificationURL | CertificateID | |
|---|---|---|---|
| Alice Chen | alice@example.com | https://verify.example.com/c/ABC123 | CERT-2025-0042 |
| Bob Martinez | bob@example.com | https://verify.example.com/c/DEF456 | CERT-2025-0043 |
You can encode any column as a QR code — URLs, IDs, email addresses, plain text, or structured data.
Step 2 — Place a QR Code Field
In the Mergram editor, drag the column header from the sidebar onto your PDF page. In the field properties panel, set the render type to QR Code.
Position the bounding box where you want the QR code to appear. QR codes scale to cover the bounding box width and maintain their square aspect ratio — they will always be perfectly square regardless of the bounding box dimensions.
Recommended size
For reliable scanning, make the bounding box at least 1.5 cm (0.6 inches) wide on the printed page. Larger codes scan faster and from greater distances. If the code will be scanned from a screen, 2 cm or larger is ideal.
Step 3 — Configure Field Options
Adjust the QR code field settings:
- Position — Drag to place anywhere on any page
- Size — Resize the bounding box to control the QR code dimensions
- Margin — Add padding around the QR code for a quiet zone (improves scan reliability)
- Page — Place QR codes on any page of a multi-page PDF
Step 4 — Preview and Generate
Use the row selector to preview QR codes with real data from any row. Scan the preview with your phone to verify the encoded content is correct.
When satisfied, generate your documents:
- Individual PDFs — One file per row, each with its own QR code, packaged as ZIP
- Combined PDF — All pages in one document
- Email delivery — Send each PDF with its unique QR code as an email attachment
Preview tip
QR codes in the browser preview are rendered at screen resolution. The final generated PDFs contain high-resolution PNG QR codes for crisp printing. Always verify with a test scan on the generated output.
QR Code Use Cases
Certificate Verification
Add a verification QR code to certificates and diplomas. Each code links to a unique verification URL — anyone can scan to confirm the document is authentic. This is widely used for:
- Online course completion — Learners share certificates; employers scan to verify
- Professional certifications — Industry bodies issue verifiable credentials
- Academic diplomas — Universities add verification to digital and printed diplomas
Event Check-In
Generate unique check-in QR codes for every attendee. Print on badges, tickets, or confirmation emails. Staff scan at the door for instant check-in. Benefits:
- Fast entry — Scan takes under a second per person
- Fraud prevention — Each code is unique and tied to a specific registration
- Real-time tracking — Know exactly who has checked in
Payment Links
Embed payment QR codes on invoices. Each code contains a payment URL specific to that invoice. Recipients scan with their phone to pay instantly — no manual data entry, no copy-pasting amounts.
- Works with PayPal, Stripe, UPI, and any payment URL
- Reduces late payments by removing friction
- Each invoice gets a unique payment link
Product Identification
Add product QR codes to labels, tags, and spec sheets. Each code encodes a product ID, serial number, or URL linking to the product page.
- Inventory management — Scan to look up stock levels and locations
- Warranty registration — Customers scan to register their purchase
- Product information — Link to spec sheets, manuals, or support pages
Combine with barcodes
Use QR codes for consumer-facing interactions (scanning with a phone) and barcodes (Code 128, EAN-13) for internal scanning with laser scanners. Both can appear on the same template.
vCards and Contact Sharing
Encode vCard data (.vc3 format) as a QR code. When someone scans it, their phone prompts to save the contact. Use cases:
- Business cards — Print a QR code on business card PDFs
- Conference badges — Attendees scan each other’s badges to connect
- Employee directories — Print team member pages with scannable contact info
Tracking and Analytics
Embed unique tracking URLs as QR codes. Each recipient gets a different link, so you can track who engaged with the material. Use UTM parameters or unique identifiers to attribute scans to specific recipients.
Combining QR Codes with Other Features
QR Codes + Email Delivery
Generate PDFs with unique QR codes and send them as email attachments. Each recipient receives their own PDF with their own scannable code — perfect for event tickets, payment links, and verification certificates.
QR Codes + Password Protection
Encrypt QR-coded PDFs with per-recipient passwords. The recipient enters their password to open the PDF, then scans the QR code inside. Two layers of security for sensitive documents.
QR Codes + Image Fields
Add both QR codes and dynamic images on the same template. For example, an ID card with an employee photo (image field) and a check-in QR code — both personalized from spreadsheet data.
QR Codes + Custom Fonts
Use custom fonts for text fields alongside QR codes. Upload a corporate font for names and titles while embedding QR codes for machine-readable data. The combination produces professional, scannable documents.
Best Practices
-
Always add a quiet zone — Set a margin of at least 4 modules (the smallest square unit in a QR code) around the code. Without a quiet zone, scanners may fail to read the code, especially when it’s printed near text or borders.
-
Test with real scanning — Before running a full batch, generate a test PDF and scan the QR code with your phone. Verify the encoded content is correct and the code scans reliably at the intended size.
-
Keep encoded data concise — QR codes with less data are easier to scan. Use short URLs (bit.ly, your own redirect service) instead of long query strings. Shorter content produces denser, more scannable codes.
-
Size appropriately for the scanning distance — Event badges scanned from a phone at arm’s length need larger codes than product labels scanned with a dedicated scanner. Test at the actual distance your users will scan from.
-
Use HTTPS URLs — If encoding URLs, always use HTTPS. Some phone cameras warn users before opening HTTP links, creating friction. HTTPS links open seamlessly.
-
Verify data quality — Ensure the spreadsheet column for QR code data is complete and correct. Empty cells produce blank output; malformed URLs produce broken codes. Preview multiple rows before generating.
Get Started
Add dynamic QR codes to your merged PDFs in minutes. Upload a template, connect your spreadsheet, drag a column onto the page as a QR code field, and generate. Each PDF gets its own unique, scannable code.
Try Mergram free — create your first QR code mail merge today.