Skip to content

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.

Printing Personalized Envelopes with Mail Merge

Addressing envelopes by hand is tedious, especially for large mailings like wedding invitations, holiday cards, business correspondence, or direct mail campaigns. With Mergram, you can design an envelope template, connect your address spreadsheet, and generate print-ready envelope PDFs — each personalized with the correct recipient.

Prerequisites

Before you begin, gather the following:

Common envelope sizes

The most common business envelope is #10 (4.125 × 9.5 inches / 105 × 241 mm). For international mail, DL (110 × 220 mm) is standard. Larger envelopes include C5 (162 × 229 mm, fits A5 folded once) and C4 (229 × 324 mm, fits A4 flat). Check your envelope packaging for exact measurements.


Common Envelope Types and Use Cases

Envelope TypeSizeBest For
#10 Business4.125 × 9.5 inInvoices, letters, statements
DL110 × 220 mmInternational business correspondence
C5162 × 229 mmA5 invitations, booklets, catalogs
C4229 × 324 mmA4 documents, contracts, reports
A2 Invitation4.375 × 5.75 inWedding RSVPs, greeting cards, thank-you notes
6 × 9 Booklet6 × 9 inMarketing mailers, promotional booklets

Setting Up Your Envelope Template

Step 1: Create the Base PDF

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

  1. Use a tool like Google Docs, Word, or Canva to create a page with custom dimensions
  2. Export as PDF with no margins
  3. Upload the blank PDF to Mergram

Use exact dimensions

Precision matters for envelope printing. Even a small size mismatch causes address misalignment. Measure your physical envelopes and match the PDF page size exactly — including the width and height orientation.

Step 2: Place Mailing Address Fields

In the Mergram editor, drag columns from your data panel onto the canvas to create text fields. Position the mailing address in the center-right area of the envelope:

Use 10–12pt font for the mailing address for readability.

Step 3: Add a Return Address

Place the return address in the top-left corner of the envelope:

  1. You can use static text if the return address is the same for all envelopes
  2. Or map merge fields (SenderName, SenderStreet, etc.) if the return address varies
  3. Use a smaller font size (8–9pt) for the return address

Step 4: Add a Barcode for ZIP Codes (Optional)

For USPS automation-compatible mail:

  1. Select the Zip column from your data fields
  2. Change the render type to “Barcode”
  3. Position the barcode below the mailing address or in the bottom-right corner
  4. Resize to fit comfortably within the envelope width

Preparing Your Address Spreadsheet

Organize your data with one row per envelope. Use separate columns for each address component:

FirstNameLastNameCompanyStreetCityStateZip
AliceChenAcme Corp123 Main StSpringfieldIL62701
BobMartinez456 Oak AveAustinTX73301
CarolJohnsonInitech789 Elm BlvdPortlandOR97201

International addresses

For international mail, add Country as a separate column and place it on the last line of the address. Use appropriate postal code fields for each country (ZIP, postcode, EIRCODE, etc.).


Printing Your Envelopes

After merging, print the generated PDFs with these settings:

SettingRecommended ValueWhy
Page scalingNone (100%)Prevents address shifting
Page sizeMatch envelope exactlyCorrect fit in printer tray
OrientationLandscape (for #10)Envelopes feed differently than letter paper
Feed methodEnvelope tray or manual feedEnvelopes need special paper handling

Test on plain paper first

Before printing on envelopes, print one page on plain paper. Hold it over an envelope against a light source to check alignment. Adjust field positions in the editor if the address is off-center, then reprint on envelopes.


Tips for Better Envelope Output

  1. Leave margin from edges — Keep text at least 0.5 inches from envelope edges to account for printer feed margins
  2. Use clean fonts — Sans-serif fonts like Inter, Arial, or Helvetica scan well for automated mail processing
  3. ZIP +4 for barcodes — If you have the extended ZIP+4 code, use it in your barcode field for faster USPS processing
  4. Avoid dark backgrounds — Some printers struggle with heavy ink coverage on envelope paper
  5. Batch by size — If you use multiple envelope sizes, create a separate template for each size rather than mixing them

Common Issues and Troubleshooting

Address prints off-center: This is almost always a page size mismatch. Verify that your template PDF matches your envelope’s exact dimensions. Also check that print scaling is set to “Actual Size” or “None.”

Text is too large or too small: Adjust the font size in the field properties panel. Envelopes have limited space — 10–12pt works for most #10 and DL envelopes.

Printer jams on envelopes: Use the manual feed or envelope tray on your printer. Make sure the envelope orientation matches what your printer expects (some printers feed envelopes landscape, others portrait).

Get Started

Create a blank PDF at your envelope size, upload your address spreadsheet, and design your envelope layout in the Mergram editor. Preview with real data, then generate all your envelopes in one batch.

Step-by-step guide

  1. 1

    Set Up Envelope Dimensions

    Create a blank PDF with your envelope's exact dimensions (e.g., 4.125 x 9.5 inches for #10). Upload it as your template.

  2. 2

    Place Address Fields

    Drag columns from your spreadsheet onto the canvas. Position the mailing address in the center and return address in the top-left.

  3. 3

    Connect Your Data

    Upload your Excel or CSV file with columns for name, street, city, state, and ZIP code.

  4. 4

    Preview and Merge

    Preview with real data to verify alignment. Then merge to generate envelope PDFs ready for printing.

Frequently asked questions

What envelope sizes does Mergram support?
Mergram supports any custom page size. Set your canvas dimensions to match your envelope — common sizes include #10 (4.125 x 9.5 inches), DL (110 x 220 mm), C5 (162 x 229 mm), and C4 (229 x 324 mm). The editor places fields at exact positions on the envelope face.
Can I add a return address to my envelopes?
Yes. Place your return address fields in the top-left corner of the canvas. You can use static text fields for a fixed return address, or map merge fields if the return address varies by sender or region.
How do I print envelopes from the generated PDF?
Generate your merged PDF, then print directly from your PDF reader. Set the page size to match your envelope dimensions exactly. Use your printer's envelope feed tray and select 'No Scaling' or 'Actual Size' to prevent misalignment.
Can I add a POSTNET or barcode for ZIP codes?
Yes. Set a field's render type to 'Barcode' and map it to your ZIP code column. Code 128 format barcodes are commonly used for USPS automation-compatible mail.
Can I put both the return address and mailing address on the same envelope?
Absolutely. Place the return address fields in the upper-left area and the mailing address fields in the center of the envelope. Position them exactly where you want them to appear when printed.
What's the best font size for envelope addresses?
Use 10–12pt for the mailing address and 8–9pt for the return address. USPS recommends at least 8pt for machine-readable mail. Avoid decorative or script fonts — use clean sans-serif or serif fonts for reliable delivery.

Ready to try it yourself?

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

Related articles