Skip to content

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.

Creating Personalized Postcards with Mail Merge

Direct mail postcards remain one of the highest-response marketing channels. Personalized postcards — with the recipient’s name, a tailored message, and a relevant photo — outperform generic mailers significantly. Mergram lets you design a postcard template, connect your recipient data, and generate hundreds or thousands of unique postcards in one operation.

Prerequisites

Before you begin, gather the following:

Standard postcard sizes

Common postcard sizes include 4 × 6 in (most economical for printing and postage), 5 × 7 in (more space for design), and 6 × 9 in (large format for maximum impact). USPS requires a minimum size of 3.5 × 5 inches for mailable postcards. Check with your printer or mailing service for supported sizes.


Postcard Layout Considerations

AreaPositionContent
Front (face)Full surfaceMarketing image, headline, personalization
Back leftLeft half of backMessage body, sender info, QR code
Back rightRight half of backRecipient name and mailing address
Stamp areaTop-right of backReserved for postage

Leave space for postage and barcode

USPS automated mail processing requires clear space in the top-right corner for the stamp and the bottom edge for the Intelligent Mail barcode. Keep your address and design content within the safe area — at least 0.75 inches from the bottom edge and 0.625 inches from the right edge on the address side.


Designing Your Postcard Template

Step 1: Create the Base PDF at Postcard Size

Create a blank PDF with your postcard’s exact dimensions. You can:

  1. Use Canva, Figma, or Photoshop to design the postcard background
  2. Set the canvas size to your target postcard dimensions (e.g., 6 × 4 inches)
  3. Export as a PDF with no margins
  4. Upload the PDF to Mergram

Design the background separately

Create your postcard background image (colors, patterns, branding) in a design tool, then upload the PDF to Mergram for text and image field placement. This keeps the static design elements crisp and separate from the variable data fields.

Step 2: Place Text Fields

In the Mergram editor, drag columns from your data panel onto the canvas:

Use 10–12pt for address text and 14–18pt for headlines or greetings.

Step 3: Add Image Fields for Personalized Photos

To include unique photos on each postcard:

  1. Upload all images to a media album in Assets → Media
  2. In the editor, add an image field by selecting a column and setting its render type to “Image”
  3. Map the field to a column containing image filenames (e.g., Photo.jpg)
  4. Resize the image field to fit your postcard layout
  5. Images scale to fill the bounding box width while maintaining aspect ratio

Image matching

Spreadsheet cell values are matched case-insensitively against media names in your album. If a cell contains “beach.jpg”, Mergram matches any uploaded file named “beach.jpg”, “Beach.JPG”, or even just “beach” (stem fallback). If no match is found, the field is skipped with a warning.

Step 4: Add a QR Code (Optional)

Add a scannable QR code linking to a personalized URL:

  1. Create a TargetURL column in your spreadsheet with unique URLs per recipient
  2. In the editor, place a field and set its render type to “QR Code”
  3. Map it to the TargetURL column
  4. Position it in a corner of the postcard

Preparing Your Recipient Spreadsheet

Organize your data with one row per postcard. Include all variable fields:

FirstNameLastNameStreetCityStateZipMessagePhotoOfferCode
AliceChen123 Main StSpringfieldIL62701Welcome to the neighborhood!spring.jpgSAVE20
BobMartinez456 Oak AveAustinTX73301Your summer special is heresummer.jpgSAVE30
CarolJohnson789 Elm BlvdPortlandOR97201A gift just for yougift.jpgGIFT15

Keep messages short

Postcard space is limited. Aim for 1–2 sentences of personalized text. Longer messages look cramped and reduce readability. Use the front for the visual hook and the back for the short message plus address.


Merging and Output

Output Modes

Choose the right output format for your workflow:

ModeBest ForDetails
Individual PDFsMailing service upload, per-recipient filesOne PDF per postcard, named with your template
Combined PDFBatch printingAll postcards in a single file
ZIP archiveArchiving, service handoffIndividual PDFs in one downloadable ZIP

Filename Templates

For individual output, set clear filenames:

TemplateExample Output
Postcard_[[LastName]]_[[Zip]]Postcard_Chen_62701.pdf
Campaign_[[OfferCode]]_[[FirstName]]Campaign_SAVE20_Alice.pdf
[[FirstName]]_[[LastName]]_PCAlice_Chen_PC.pdf

Tips for Print-Ready Postcards

  1. Use 300 DPI images — A 4 × 6 inch postcard needs at least 1200 × 1800 pixels. Lower resolution looks fine on screen but blurry in print
  2. Account for bleed area — Add 0.125 inches on each side if your printer requires bleed. Extend background colors into the bleed area to avoid white edges
  3. Use CMYK-safe colors — Bright neon and RGB-only colors may shift during printing. Use colors that convert cleanly to CMYK
  4. Keep text away from edges — Maintain at least 0.25 inches of margin from all trimmed edges for safe text placement
  5. Embed fonts or use outlines — If your design tool supports it, convert text to outlines or embed fonts to prevent substitution during printing
  6. Test with a small batch first — Generate 5–10 postcards, print them, and verify quality before running the full batch

Common Issues and Troubleshooting

Images look blurry in the PDF: The source images may be too low resolution. Check that your uploaded photos meet the 300 DPI minimum for print at the field size on the postcard.

Address text is too large: Reduce the font size for address fields. USPS address blocks typically use 10–12pt. Make sure the address fits within the right half of the postcard back.

QR codes don’t scan: Ensure the QR code bounding box is large enough — at least 1 inch square for reliable scanning. The URL in your spreadsheet should be a valid, complete URL starting with https://.

Colors look different when printed: This is a CMYK vs. RGB issue. Design your background in CMYK color space if your design tool supports it. Avoid very bright or fluorescent colors that can’t be reproduced in print.

Get Started

Create a postcard-sized PDF, upload your recipient spreadsheet, and design your layout in the Mergram editor. Add personalized images, preview with real data, and generate print-ready postcards in seconds.

Step-by-step guide

  1. 1

    Set Postcard Dimensions

    Create a blank PDF at your postcard size (e.g., 4 x 6 inches). Upload it as your template in Mergram.

  2. 2

    Design the Layout

    Place text fields for recipient name, address, and personalization. Add image fields for photos or logos.

  3. 3

    Connect Your Data

    Upload an Excel or CSV file with recipient names, addresses, messages, and image filenames.

  4. 4

    Preview and Merge

    Preview with real data to verify layout and images. Merge to generate print-ready postcard PDFs.

Frequently asked questions

What postcard sizes does Mergram support?
Mergram supports any custom page size. Set your canvas to standard postcard dimensions: 4 × 6 inches, 5 × 7 inches, 5.5 × 8.5 inches, or 6 × 9 inches. The template dimensions determine the printed output size.
Can I add photos to each postcard from a spreadsheet?
Yes. Upload images to a media album in Mergram, then create image fields on the canvas. Map each image field to a spreadsheet column containing filenames. Each postcard renders with the matching photo.
How do I design both sides of a postcard?
Create two separate templates — one for the front and one for the back. Merge each template with the same data, then combine the front and back PDFs for each recipient. Alternatively, design a single-sided postcard and print two-sided using your printer's duplex feature.
Can I send postcards to a mailing service?
Yes. Generate individual PDFs named with recipient identifiers, then upload them to your mailing service's portal (such as Postcards, Click2Mail, or Postal). Most services accept PDF uploads in standard postcard sizes.
What resolution should my images be for postcard printing?
Use images at 300 DPI for print quality. A 4 × 6 inch postcard needs images that are at least 1200 × 1800 pixels. Lower resolution images may look acceptable on screen but appear blurry when printed.
Can I include a QR code on each postcard?
Yes. Add a field with the render type set to 'QR Code' and map it to a column containing URLs or codes. Each postcard gets a unique, scannable QR code linking to a personalized landing page or offer.

Ready to try it yourself?

Start merging PDFs in minutes — free account required, no credit card needed.

Related articles