The fastest way: use Word's mail merge feature

Word has a built-in tool called mail merge that creates mailing labels from a list of addresses. You start with a spreadsheet of names and addresses (in Excel, Google Sheets, or even a Word table), then tell Word to print each address on a separate label. Word handles the positioning automatically so each address lands in the right spot on your label sheet.

The process takes three steps: prepare your address list, set up a label document in Word, and connect the two. Most people finish in 10 to 15 minutes once they know where to click.

Key Takeaways

  • Mail merge is the built-in Word feature that prints addresses from a list onto label sheets, and it works with Excel files, Google Sheets, or Word tables.
  • You need your addresses in a spreadsheet first, with column headers like "First Name," "Last Name," and "Address" in the first row.
  • Word's Mailings tab contains the mail merge tools; you start by selecting your address file, then insert merge fields onto a blank label template.
  • Label sheets come in standard sizes (Avery 5160 is the most common for address labels), and Word has built-in templates for most brand names and sizes.
  • Test your merge on regular paper first by printing a few labels before you run the full batch on expensive label sheets.

Prepare your address list before you open Word

Your addresses need to live in a spreadsheet with clear column headers. Open Excel, Google Sheets, or create a table in Word itself. In the first row, type headers: "First Name," "Last Name," "Street Address," "City," "State," "ZIP Code." Then fill in one address per row below.

Save this file and remember where it is. If you use Google Sheets, download it as an Excel file (.xlsx) first — Word connects more reliably to Excel files than to cloud sheets. The file does not need to be fancy; plain text in columns is all Word needs.

Check that every address row has the same information in the same columns. If some rows are missing a city or ZIP code, Word will still print them, but the label will look incomplete. Fix these before you start the merge.

Set up a new label document in Word

Open a blank Word document. Go to the Mailings tab at the top of the screen. Click Start Mail Merge, then select Labels from the dropdown menu.

A dialog box opens asking you to choose a label size. If you bought Avery labels (the most common brand), find your product number on the box — it is usually on the front or back. Type that number into the search field. Word will show you the matching template. If you use a different brand like Staples or Office Depot, search for that brand name instead. Click OK once you find your label size.

Word now shows you a blank page with a grid of empty label boxes. This is your template. Do not type anything yet — you are about to connect this to your address list.

Connect your address file to the label template

Still in the Mailings tab, click Select Recipients. Choose Use an Existing List. A file browser opens. Navigate to the spreadsheet you saved earlier and click Open.

A dialog box may ask you to confirm which sheet or table to use. If your addresses are on the first sheet of an Excel file, Word usually picks it automatically. Click OK.

Word now knows where your addresses are. The label template is still blank because you have not told Word which address fields to print where. That comes next.

Insert merge fields onto the first label

Click in the first label box (the top-left one). Go to the Mailings tab and click Insert Merge Field. A dropdown list shows all your column headers from the spreadsheet — "First Name," "Last Name," "Street Address," and so on.

Click First Name. Word inserts a placeholder that looks like <<First Name>> into the label. Press Enter to move to the next line. Click Insert Merge Field again and select Last Name. Press Enter. Continue this way, adding Street Address, City, State, and ZIP Code, pressing Enter between each field.

When you are done, the first label should show all the merge fields stacked vertically. The exact order depends on how you want the address formatted — typically First Name and Last Name on the first line, street address on the second, and City, State ZIP on the third.

Now click in the second label box. Go to Mailings and click Update Labels. Word copies the same merge field layout to every label on the page. You only set it up once.

Preview and print a test batch

Before you print on actual label sheets, preview how the addresses will look. In the Mailings tab, click Preview Results. Word replaces the merge field placeholders with real addresses from your list. Scroll through a few labels to check that names and addresses are in the right places and that nothing is cut off.

If something looks wrong — an address is in the wrong order, or text is too close to the edge — go back and edit the merge fields. Click Preview Results again to turn off the preview, then click in a label and adjust the fields. Click Preview Results again to see the changes.

Once the preview looks right, print a test page on regular paper. Load plain white paper into your printer, go to Mailings, click Finish & Merge, and select Print Documents. Print just one page. Hold it up to a sheet of blank labels to see if the addresses line up with the label boxes. If they do, you are ready to print on actual labels.

Print the full batch on label sheets

Load your label sheets into the printer. Go to Mailings, click Finish & Merge, and select Print Documents. A print dialog opens. Choose how many copies you want and which pages to print. If you only need labels for the first 50 addresses, type "1-50" in the page range. Click Print.

Word prints one address per label across the entire sheet. Let the ink dry for a few seconds before you handle the labels, especially if you are using an inkjet printer.

Frequently Asked Questions

What if I only want to print labels for some of the addresses in my list?

After you preview the results, go to Mailings and click Finish & Merge, then Print Documents. In the print dialog, type the page numbers you want in the "Pages" field. If each page holds 30 labels and you only want the first 60 addresses, type "1-2" and click Print.

Can I add a company name or a second address line?

Yes. Add those as separate columns in your spreadsheet with headers like "Company" or "Address Line 2." Then insert those merge fields into the label in the order you want them. Press Enter between each field to put them on separate lines.

What if my addresses are in a Google Sheet?

Download the Google Sheet as an Excel file (.xlsx) first. Go to File, Download, and choose "Microsoft Excel." Save it to your computer, then use that file in Word's mail merge. Word does not connect directly to Google Sheets, but it works perfectly with downloaded Excel files.

Can I edit individual labels after the merge is done?

Yes, but it is easier to fix the source spreadsheet and redo the merge. If you need to change just one or two labels, click Finish & Merge and select Merge to New Document. Word creates a new document with all the printed addresses. You can then edit any label by hand in that document and print it separately.

Why are some addresses cut off at the edges?

Your label template size does not match your actual label sheet, or the merge fields are positioned too close to the edge. Go back to Mailings, click Start Mail Merge, select Labels, and double-check that you selected the correct label size. If the size is right, click in the label and move the merge fields slightly toward the center of the label box.