How to print envelopes from an Excel list

The problem: envelopes from a spreadsheet

You have a list of names and addresses in Excel (or Google Sheets). You need to print envelopes—maybe 50, maybe 500. Many people search for a faster way to print envelopes from an Excel list. You can do it with Word mail merge, or use List Processor and skip the wizard.

How to print envelopes with Word mail merge

In Word, you use Mailings → Start Mail Merge → Envelopes, then:

1. Set the envelope size in the Envelope Options dialog (#10, 6×9, etc.).
2. Select Recipients → Use an Existing List and browse to your Excel file. Choose the sheet and range. If the workbook has multiple sheets or the data isn’t in the first rows, you have to get this right or the merge fails.
3. Insert the merge fields in the delivery address area: «AddressBlock» or individual fields like «FirstName», «AddressLine1», «City», «State», «PostalCode». Your Excel columns must match what Word expects, or you map them in the dialog.
4. Preview Results and fix any misaligned or blank envelopes. If one row has a missing ZIP or an extra comma, the layout can break.
5. Finish & Merge → Print Documents (or Edit Individual Documents to get a PDF).

This works when your data is clean and your column names match. When it doesn’t, you’re debugging the data source, the field mapping, or the envelope template—often 20–30 minutes before the first good print.

How to print envelopes from Excel with List Processor

Step 1: Get your list from Excel

Copy the columns that contain names and addresses from your spreadsheet, or export the sheet to CSV and upload the file. List Processor doesn’t require column headers to match specific merge field names—it parses the content and detects addresses automatically.

Step 2: Paste or upload

Create a free account at List-Processor.com (no credit card), then add a new list. Paste your copied cells or upload your CSV. The parser standardizes addresses and splits out name, street, city, state, and ZIP. If something looks off, you can tweak it in the preview.

Step 3: Choose envelope size and output

Select “Envelopes” as the output type. Pick your size—#10 (standard business), 6×9, 9×12, or custom. Add your return address if you want it on every envelope. Optionally attach a template or use your letterhead for a merged letter instead of (or in addition to) envelopes.

Step 4: Download and print

Generate your PDF. You get a single, print-ready file with one envelope per page (or your chosen layout). Send it to your printer or a mail house. Done.

List Processor is faster than Word mail merge for envelopes

With Word, you set up a data connection, choose the correct sheet/range, insert merge fields into the envelope layout, and preview. One wrong step and you get blank envelopes or misaligned text. With List Processor there’s no field mapping—paste, choose envelope size, download. Most users go from Excel to printed envelopes in under five minutes the first time at List-Processor.com.