Mail merge labels online
Mail merge labels in the browser. Import Excel, CSV, or Google Sheets, place the fields, and print on Avery sheets or a thermal roll. One row is one label. You do not need Word. Proof the longest name, then print. No signup. Filter the sheet first if you only need today's rows.
Sizes
Merge onto 5160
2.63 x 1 in. The classic merge: one person per row, thirty labels per sheet, no Word field codes.
Merge onto 5163
4 x 2 in. Fewer labels, larger type. Use it when the merge includes a company line and a second address line.
Merge onto DYMO
1.125 x 3.5 in. The same list, one label at a time, on a 30252 roll. There is no sheet to align.
Merge onto DK-1201
3.54 x 1.14 in. Brother version of the address merge. Load DK-1201 before you map the columns.
Merge names onto badges
3.5 x 2.25 in. A guest list merge. The large line is the first name, not the full postal address.
Merge orders onto 4x6
4 x 6 in. An order export is a merge too. Each row is one parcel.
Mail merge labels online, without Word
A mail merge is a list plus a layout. Word is one way to do it. It is not the only way, and it is the way that breaks when the Avery template and the printer disagree. Here the layout is the template you open, and the list is the file you import. Each row is one merged label. You can see the record before you print it.
Keep the merge fields boring. Name, street, city, region, postal code. If you need a greeting, put the greeting in its own column in the sheet ("Hi Sam") rather than trying to concatenate it inside the label. What you see on the proof is what prints.
- Build the list with a header. One recipient per row.
- Open the 5160 card, or the thermal address card if you are not using sheets.
- Import the list. Map the five address lines.
- Step to a long name and a short name.
- Print one sheet. If the cells sit on the stickers, print the merge.
Google Sheets as the data source is print labels from Google Sheets. The Word habits this replaces are on print labels without Word. Address-only jobs are address labels.
Questions
How do mail merge labels work here?
Import the recipient list, map the columns to the lines on the label, proof a long name, and print.
Do I need Word for a mail merge?
No. The list can be Excel, CSV, or a Sheets download. The layout is the template you opened.