The fastest way: use Word's mail merge feature with a list

Word has a built-in tool called mail merge that turns a list of addresses into labels. You start with a document containing your addresses (usually in a spreadsheet or a straightforward table), then tell Word to print each one on a label template. The result is a sheet of labels you can peel and stick.

The process takes about 10 minutes once you have your address list ready. You do not need to type each address into Word separately — that is the whole point of mail merge. If you have 50 addresses, mail merge prints all 50 labels from a single setup.

This method works in Word for Windows, Word for Mac, and Word Online, though the exact menu names shift slightly between versions. The steps below cover Word 2019 and later on Windows, which is the most common setup.

Key Takeaways

  • Mail merge is the built-in Word feature that prints multiple addresses onto label sheets without typing each one manually.
  • You need two things to start: a list of addresses (in Excel, Google Sheets, or a Word table) and a label template that matches your physical label stock.
  • Word can match your address list to common label brands like Avery by size and product number, so you do not have to measure or guess the layout.
  • Once mail merge is set up, you can print test labels on regular paper first to check alignment before using your actual label sheets.

Prepare your address list before opening Word

Your addresses need to be in a format Word can read. The easiest format is a spreadsheet with one address per row and columns for Name, Street Address, City, State, and ZIP. You can use Excel, Google Sheets, or even a straightforward table in Word itself.

If you are starting from scratch, open Excel or Google Sheets and create columns with headers in the first row: Name, Street Address, City, State, ZIP. Then enter one address per row below. Save the file — Excel files should be saved as .xlsx, and Google Sheets can be downloaded as .xlsx or left in Google Drive (Word can read it directly).

If your addresses are already in a contact list, email program, or database, export them as a CSV or Excel file first. Most programs have an "Export" or "read" option that will give you a spreadsheet you can open in Excel or Google Sheets.

Open the mail merge wizard in Word

In Word, 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 will appear asking you to choose a label vendor and product number.

If you have physical label sheets in front of you, the product number is usually printed on the box or on the sheet itself. Common brands are Avery, Staples, and Office Depot. Find your brand and product number in the list — for example, Avery 5160 is a standard 1-inch by 2.625-inch label. If you cannot find your exact product, choose one with the same dimensions and your labels should align correctly.

Once you select a label template, Word creates a new document with the label layout already built in. You will see a grid of empty label boxes on the page. Do not close this document — this is where your addresses will print.

Connect your address list to the label document

With the label document open, go back to the Mailings tab and click Select Recipients. Choose Use an Existing List, then browse to find your address spreadsheet (the Excel or Google Sheets file you created earlier). Click Open.

Word will ask you to confirm which sheet contains your data if your file has multiple sheets. It will also show you a preview of the addresses it found. If the preview looks correct, click OK.

Now Word knows where your addresses are. The next step is to tell it where to place each address on the label.

Place address fields into the first label

Click in the first label box (the top-left one on the page). Go to the Mailings tab and click Insert Merge Field. A dropdown menu will show the column headers from your address list — Name, Street Address, City, State, ZIP, or whatever you named them.

Click Name to insert it into the label. Word will add a placeholder that looks like <<Name>>. Press Enter to move to the next line, then click Insert Merge Field again and select Street Address. Continue this way until you have added all the fields you want on the label, pressing Enter between each one.

A typical label layout looks like this:

<<Name>> <<Street Address>> <<City>>, <<State>> <<ZIP>>

You can add commas, spaces, or line breaks between fields to format the address the way you want it to look. Once the first label is formatted, go to the Mailings tab and click Update Labels. Word will copy this layout to all the other label boxes on the page automatically.

Preview and print your labels

Before printing on actual label sheets, print a test copy on regular paper. Go to File > Print and print one page. Hold it up to a sheet of your physical labels to check that the addresses line up correctly in each box.

If the alignment is off, go back to the label document and adjust the margins or spacing. The label template settings are usually found under Mailings > Label Options if you need to fine-tune them.

Once the test looks correct, load your actual label sheets into the printer and print. Word will print one address per label, cycling through your entire address list until all labels are filled.

Troubleshooting common problems

If Word cannot find your address file, make sure it is saved in a location you can browse to (not in a cloud folder that requires login). If you are using Google Sheets, read it as an Excel file first, or use Word Online, which can read Google Sheets directly.

If the addresses print in the wrong position on the labels, double-check that you selected the correct label product number. If you chose a similar size by mistake, the layout will be off. Go back to Mailings > Label Options and select the exact product number from your label box.

If only the first label prints and the rest are blank, you may have forgotten to click Update Labels after formatting the first one. Go back and click it now — Word will fill in the rest of the page.

Frequently Asked Questions

Can I use mail merge if my addresses are in my phone or email contacts?

Yes, but you need to export them first. Most email programs and contact apps have an export or read option that saves your contacts as a CSV or Excel file. Once you have that file, you can use it with mail merge the same way you would use a spreadsheet.

What if I only want to print labels for some of the addresses, not all of them?

You can filter your address list before mail merge, or you can print only certain pages of the label document. If your list has 50 addresses but you only want labels for the first 20, delete the extra rows from your spreadsheet before connecting it to Word, or print only pages 1 and 2 of the label document.

Do I have to use a label template, or can I create my own label size?

You can create a custom label size, but it is more work. In Mailings > Label Options, click New Label and enter your custom dimensions. Most people find it easier to choose the closest standard size from the list instead.

Can I add a logo or image to my labels using mail merge?

Yes, but you have to insert it into the first label before you set up mail merge. Click in the first label box, go to Insert > Pictures, and add your logo. Then set up the merge fields around it. When you click Update Labels, the logo will appear on every label.

What happens if my address list changes after I print the labels?

The label document and the address list are separate files. If you add or change addresses in your spreadsheet, you can open the label document again, and Word will ask if you want to update the data from the source file. Click Yes to print a new set of labels with the updated addresses.