Create and print mailing labels for an address list in Excel

Creating and printing mailing labels from an address list in Excel is easy using Microsoft Word’s Mail Merge feature. Here’s a step-by-step guide:

✅ What You Need:

• An Excel file with your address list.
• Microsoft Word to perform the Mail Merge.
• Blank label sheets (e.g., Avery 5160 or similar) in your printer.

🔢 Step 1: Prepare Your Address List in Excel

Make sure your Excel sheet is organized like this:

• The first row must contain headers.
• Save and close the Excel file.

📝 Step 2: Start the Mail Merge in Word

1. Open Microsoft Word.
2. Go to Mailings tab → click Start Mail Merge → choose Labels.
3. In the Label Options window:
   • Select your label vendor (e.g., Avery US Letter).
   • Select the correct Product Number (like 5160).
   • Click OK.

🔗 Step 3: Connect to Excel Address List

1. On the Mailings tab, click Select Recipients → choose Use an Existing List.
2. Browse to and select your Excel file → pick the correct worksheet → click OK.

🧩 Step 4: Insert Address Fields

1. Click into the first label cell (top-left label).
2. Click Insert Merge Field, and add fields like this:

«First_Name» «Last_Name»
«Address»
«City», «State» «ZIP»

3. Format as needed (e.g., spacing, font, alignment).
4. Click Update Labels to apply the layout to all labels.

👁️ Step 5: Preview & Print

1. Click Preview Results to see how labels will look.
2. Click Finish & Merge → choose Print Documents (or Edit Individual Documents if you want to make changes before printing).

🖨️ Step 6: Load Labels and Print

• Insert your blank label sheets into the printer.
• Print the document just like any Word file.