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

Microsoft Word has a built-in tool called mail merge that turns a spreadsheet of addresses into printable labels in minutes. You start with your address list (in Excel, Google Sheets, or even a Word table), connect it to Word's label template, and the program fills in each label automatically. This is faster and more accurate than typing addresses by hand.

The process works the same way whether you have 10 addresses or 1,000. Word pulls from your data source and creates one label per row, so if your spreadsheet has 50 names and addresses, you get 50 labels ready to print.

Key Takeaways

  • Mail merge is Word's built-in feature for creating multiple labels at once from an address list stored in Excel, Google Sheets, or a Word table.
  • You need three things: a data source with addresses, a blank Word document, and access to the Mailings tab where the mail merge tools live.
  • Word can print labels on standard label sheets (like Avery 5160) or create a single custom label if you only need one address.
  • If mail merge feels complicated, you can type addresses directly into a label template, though this takes longer for more than a few labels.

Setting up your address list before you open Word

Before you start in Word, organize your addresses in a spreadsheet or table with one address per row. Each column should hold one piece of information: first name in one column, last name in another, street address in another, city, state, and zip code each in their own column. The first row should be headers — "First Name", "Last Name", "Address", "City", "State", "Zip" — so Word knows what each column contains.

You can build this list in Microsoft Excel, Google Sheets, or even a straightforward Word table. Save the file and keep it open or nearby — you will need to point Word to it in a moment. If your addresses are already in an email program or contact manager, you can usually export them as a spreadsheet, which saves retyping.

Opening 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 open asking you to choose a label size. If you are using standard Avery labels (the most common kind), find your label number in the list — Avery 5160 is the standard address label size. If you have a different brand or size, look for the matching number on your label sheet box.

Word will create a new document with a grid of empty label boxes, one for each label on a standard sheet. This is your template. Do not close it — you are about to connect it to your address list.

Connecting your address list to the label template

With your label template open, go back to the Mailings tab and click Select Recipients. Choose Use an Existing List, then browse to find the spreadsheet or table where you saved your addresses. Click it and open it. Word will ask you to confirm which sheet contains your data (if you are using Excel with multiple sheets) and will show you a preview of the addresses it found.

Once Word connects to your data, click in the first label box in your template. Go to Mailings again and click Insert Merge Fields. A list will appear showing the column headers from your address list — "First Name", "Last Name", "Address", and so on. Click each field in the order you want it to appear on the label, pressing Enter between lines. For a typical address label, you would insert First Name, then Last Name, then Address, then City, State, and Zip on the last line.

Filling all labels at once and printing

After you have set up the first label with merge fields, go to Mailings and click Finish & Merge. Select Edit Individual Documents to see all your labels filled in with real addresses. Word will create a new document showing every label with the actual data from your spreadsheet. Review a few to make sure the addresses look right, then print on your label sheets.

If everything looks correct, print as you normally would — load your label sheets into the printer and use File > Print. If you only need to print some labels, you can specify the page range in the print dialog.

Creating a single label without mail merge

If you only need one or two labels, mail merge is overkill. Instead, go to Mailings, click Labels, and choose your label size. In the dialog that opens, type the address directly into the "Address" field, then click New Document. Word creates a sheet with your address on the first label and blank labels below. Print it on a label sheet and you are done.

This method is also useful if you want to create a label with something other than a mailing address — a return address, a product label, or a name tag. Just type what you need in the address field and Word will format it on the label size you chose.

Troubleshooting common label problems

If your addresses are not showing up on the labels, check that your data source is saved and closed (Word cannot read a file that is open in another program). If the merge fields are showing as <> instead of actual names, go to Mailings and click Preview Results to toggle between seeing the field codes and the actual data.

If your addresses are printing in the wrong position or running off the edge of the label, your label size setting may not match your actual sheets. Double-check the label number on your sheet box and make sure Word is set to the same size. If you are using a custom label size, you can create it by going to Mailings > Labels and clicking Options or Label Options, then New Label, and entering your measurements.

Frequently Asked Questions

Can I use mail merge with addresses from my email contacts?

Yes, but you need to export them first. Most email programs (Outlook, Gmail, Apple Mail) let you export contacts as a CSV or Excel file. Once you have that file saved, you can use it as your data source in Word's mail merge. Check your email program's settings or help section for the export option.

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

After you finish the merge and see all your labels in the new document, delete the ones you do not need. Or, before you merge, you can filter your data source to include only certain addresses — for example, only people in a specific state. This depends on whether your data is in Excel (where filtering is built in) or another format.

Can I change the font or formatting of the labels after I merge?

Yes. After you click Finish & Merge and see all your labels filled in, you can select all the text and change the font, size, or color just like you would in any Word document. Select all with Ctrl+A (or Cmd+A on Mac), then use the formatting tools in the Home tab.

What label brands and sizes does Word support?

Word includes templates for Avery, Zweckform, and several other common brands. When you open the label options, you can search by brand name or label number. If your labels are not in the list, you can create a custom label size by measuring your sheet and entering the dimensions manually in the label options dialog.

Do I need to keep my address list open while I print?

No. Once Word has merged the data into the label document, the addresses are now part of that Word file. You can close your original spreadsheet. However, if you want to make changes to the addresses later, you will need to go back to your original data source, edit it, and run the merge again.