Mail merge for labels pulls names and addresses from Excel into a template, then prints them on label sheets

A mail merge takes a list of names and addresses stored in Excel and automatically fills them into a label template in Microsoft Word. Instead of typing each address by hand onto a label, you set up the connection once, and Word prints all your labels at once. The process works in three steps: prepare your Excel data, set up a label document in Word, and run the merge.

This method works best when you have more than a handful of labels to print — roughly ten or more. For fewer labels, typing them directly is often faster. You will need Microsoft Word and Excel on the same computer, and label sheets (Avery labels are the most common, but any brand works if you know the template number).

Key Takeaways

  • Your Excel spreadsheet must have column headers in the first row — "First Name", "Last Name", "Address", "City", "State", "ZIP" — with one person per row below.
  • Word's mail merge feature connects to your Excel file and pulls data into a label template without copying and pasting.
  • You choose your label size and brand (usually Avery) from Word's built-in templates before starting the merge.
  • The merge creates a new document showing all labels; you then print that document on actual label sheets.
  • Test the merge with one or two labels before printing a full batch to catch address formatting problems.

Prepare your Excel spreadsheet with the right column structure

Open your Excel file and check that the first row contains column headers. Common headers are "First Name", "Last Name", "Address", "City", "State", and "ZIP". Each person's information goes in one row below the headers. Do not leave blank rows between entries — the merge will treat them as empty records and print blank labels.

Make sure addresses are split into separate columns if you want them formatted a certain way. For example, if you want the city, state, and ZIP on one line, you can put them in separate columns and Word will combine them during the merge. If your address is already in one column as "123 Main St, Springfield, IL 62701", that works too — just keep it as is.

Save your Excel file before moving to Word. You do not need to close it, but saving ensures Word can read the latest version. Note the exact file name and where you saved it — you will need to locate it from Word in a moment.

Set up a new label document in Word and select your label size

Open Microsoft Word and create a new blank 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 titled "Label Options" will appear. This is where you tell Word what size labels you are using. If you have an Avery label sheet, the package will show a number like "5160" or "8160" — find that number in the "Product number" list and click it. If you do not see your exact number, search for your label brand and size online to find the matching Avery equivalent; most label sheets are compatible with Avery templates.

Once you select the label size, click OK. Word will create a template with the correct spacing and margins for your labels. The document will look mostly blank with faint gridlines showing where each label will print.

Connect Word to your Excel file

With your label template open, go to the Mailings tab again and click Select Recipients. Choose Use an Existing List from the dropdown.

A file browser window will open. Navigate to the folder where you saved your Excel file, click the file name, and click Open. Word will then ask you to confirm which sheet contains your data — if your addresses are on "Sheet1", that is already selected. Click OK.

A dialog box called "Mail Merge Recipients" will appear, showing a preview of all the rows in your Excel file. Scan through to make sure all your addresses are there and that the columns are labeled correctly. If you see a row you want to skip (for example, a test entry), uncheck the box next to that row. When everything looks right, click OK.

Insert the merge fields into the label template

You are now back at your blank label template. Click in the first label area (the top-left label on the page). Go to the Mailings tab and click Insert Merge Field. A dropdown list will show all the column headers from your Excel file.

Click the first field you want — usually "First Name". Word will insert it as <<First Name>> in the label. Press Enter to go to the next line, then click Insert Merge Field again and select "Last Name". Continue adding fields in the order you want them to appear on the label, pressing Enter between lines.

A typical label layout looks like this: First Name, Last Name on the first line, then Address on the second line, then City, State, ZIP on the third line. You can type commas, spaces, or line breaks between fields to format them however you want. For example, you might type the merge field for City, then a comma and space, then the merge field for State, then a space, then the merge field for ZIP — all on one line.

Copy the label layout to all labels on the page

After you finish formatting the first label, you need to copy that layout to all the other label positions on the page. Select all the text you just created in the first label (Ctrl+A will select everything in that label area). Copy it (Ctrl+C).

Go to the Mailings tab and click Update Labels. Word will automatically paste your merge field layout into every label position on the page. You will see the template now shows the same merge fields repeated in a grid pattern — one set for each label.

Preview the merge and create the final document

Before you print, preview what the labels will actually look like with real data. Go to the Mailings tab and click Preview Results. The template will now show the first person's actual address in the first label, the second person's address in the second label, and so on. Scroll through a few labels to check that addresses are formatted correctly and that nothing is cut off.

If something looks wrong — for example, if an address is too long and runs off the label, or if a field is blank when it should not be — click Preview Results again to turn off the preview, go back to your Excel file, and fix the data. Then return to Word and preview again.

Once the preview looks correct, go to the Mailings tab and click Finish & Merge. Select Edit Individual Documents. Word will create a new document showing all your labels with actual data filled in. This new document is what you will print — your original template stays unchanged.

Print the labels on your label sheets

Load your label sheets into your printer. Go to File > Print. Check that the printer is set correctly and that the page range shows all pages (or the specific pages you want to print). Click Print.

The labels will print with each address in its correct position on the sheet. If the alignment looks off — for example, if text is printing in the wrong label box — check that you selected the correct label size in the Label Options dialog. You may need to rerun the merge with the correct template.

Frequently Asked Questions

What if my Excel file has extra columns I do not want on the labels?

You do not have to use every column. When you insert merge fields, just pick the ones you need. Extra columns in Excel will not appear on the labels unless you specifically insert them into the template.

Can I use a different program instead of Excel?

Word's mail merge also works with CSV files, Access databases, and Outlook contacts. The steps are the same — go to Select Recipients and choose your file type. CSV files work particularly well if you have data from another source.

What should I do if some addresses are missing or blank?

Check your Excel file for empty cells. During the Mail Merge Recipients step, you can uncheck any rows with missing data so Word does not print blank labels for them. Alternatively, go back to Excel, fill in the missing information, save the file, and rerun the merge.

How do I fix labels that printed in the wrong position?

This usually means the label template size does not match your actual label sheet. Check the product number on your label package and verify you selected the correct template in Word's Label Options. If you selected the wrong size, start over with a new document and choose the right template.

Can I save the merged document to print later?

Yes. After you click Finish & Merge and Word creates the new document with all the labels, save that document like any other Word file. You can close it and reopen it later to print whenever you are ready.