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, one label per row. Microsoft Word handles the actual merge — Excel just holds the data. The process takes about 15 minutes once you have your spreadsheet organized, and it beats typing addresses by hand onto 100 labels.

The basic steps are: organize your Excel data so each column is one piece of information (first name, last name, street address, city, state, zip), create a label template in Word, connect Word to your Excel file, and then print. Word does the repetitive work of filling in each address.

Key Takeaways

  • Your Excel spreadsheet must have one column for each piece of address information — separate columns for first name, last name, street, city, state, and zip code work better than one column for the full address.
  • Word's mail merge feature connects to your Excel file and automatically fills in each label with the correct row of data.
  • You set up the label template once in Word, then Word repeats it for every row in your spreadsheet.
  • Test the merge with a few labels on regular paper before printing on actual label sheets to catch formatting problems.

Organize your Excel spreadsheet before starting the merge

Open your Excel file and check that the first row contains column headers — these are the labels Word will use to match data to the right spot on your label. Your headers might be "First Name", "Last Name", "Street Address", "City", "State", and "Zip Code". Each person's information goes in one row below the headers.

Make sure there are no blank rows in the middle of your data, and delete any extra columns you do not need. Word reads from the first row of headers down to the last row with data, so a blank row in the middle will stop the merge early. Save the file when you are done — you will need the file path in a moment.

Set up a label template in Word

Open a new document in Microsoft Word. Go to the Mailings tab at the top, then click Labels. A dialog box will open asking you to choose a label size. Find your label brand and model number — Avery is the most common, and the model number is usually printed on the box. Select it from the list and click OK.

Word will create a page with empty label boxes matching your label sheet. The cursor will be in the top-left label. This is where you will set up what information goes on each label. Do not type anything yet — you are about to insert fields that Word will fill in automatically.

Insert merge fields into the first label

With the cursor in the top-left label, go back to the Mailings tab and click Insert Merge Field. A dropdown menu will show all the column headers from your Excel file. Click the first one — usually "First Name". Word will insert <<First Name>> into the label.

Press Enter to move to the next line and click Insert Merge Field again. This time select "Last Name". Keep going until you have inserted all the fields you want on the label, pressing Enter between each one. A typical label might have First Name, Last Name, Street Address, City, State, and Zip Code, each on its own line. When you are done, the first label should look like a template with placeholders instead of real names.

Connect Word to your Excel file and preview the merge

Still in the Mailings tab, click Select Recipients, then Use an Existing List. A file browser will open. Navigate to your Excel file and click Open. A dialog box may appear asking which sheet to use — if your data is on the first sheet, just click OK.

Now click Preview Results in the Mailings tab. The template will change to show real data from your Excel file in the first label. Use the arrow buttons next to Preview Results to scroll through a few labels and check that the information is in the right places. If a label looks wrong, click Preview Results again to turn off the preview, fix the template, and then turn the preview back on.

Complete the merge and print your labels

When the preview looks correct, click Finish & Merge in the Mailings tab. You have two options: Edit Individual Documents creates a new document with all the merged labels so you can review or edit them before printing, or Print Documents sends them straight to your printer. For a first merge, choose Edit Individual Documents so you can spot any problems.

A new document will open showing all your labels with real addresses filled in. Scroll through and look for anything that does not fit the label or looks misaligned. If everything looks good, go to File > Print, load your label sheets into the printer, and print. If you used Print Documents instead, just load the sheets and click OK when the print dialog appears.

Test on regular paper before printing on label sheets

The first time you merge labels, print a test copy on regular white paper. This shows you whether the addresses are positioned correctly on each label box and whether the font size is readable. Tape the test page to a sheet of labels and hold it up to a light — you will immediately see if the text lines up with the label boundaries.

If the text is too close to the edge or runs off the label, go back to the Word template, click Preview Results to turn off the preview, and adjust the margins or font size. Then preview again and print another test. Once the test looks right, you can print on actual label sheets without wasting them.

Frequently Asked Questions

What if my Excel file has a full name in one column instead of separate first and last names?

You can still do the merge, but the label will show the entire name in one place. If you want to split it later, you can edit the merged document by hand, or go back to Excel and use the "Text to Columns" feature to split the full name into two columns before redoing the merge.

Can I merge to an existing Word document instead of creating a new one?

Yes. Open your existing document, go to Mailings > Start Mail Merge, and choose the type of document. Then follow the same steps to select recipients and insert merge fields. This works for letters, envelopes, or any other document type.

What happens if my Excel file has blank cells or missing addresses?

Word will still create a label for that row, but it will be missing the information from the blank cell. The label will look incomplete. Before merging, go back to Excel and fill in any missing data, or delete rows you do not want to print.

Do I need to save the merged document?

You do not have to, but it is a good idea if you think you might need to print the same labels again later. Save it with a clear name like "Holiday Cards Merged" so you can find it. If you just need one print run, you can close it without saving.

Can I use mail merge for envelopes instead of labels?

Yes. Instead of clicking Labels, click Envelopes in the Mailings tab. The process is the same — you insert merge fields for the address, connect to your Excel file, and print. Envelope sizes vary, so make sure you select the right one from the dialog box.