How to Create Mail Merge Labels in Microsoft Word (2026)

How to Create Mail Merge Labels in Microsoft Word (2026)

Mail merge labels automate the process of creating address labels for mailings. Instead of printing individual labels, merge your contact database with a label template to generate all labels at once. This saves hours and eliminates manual errors.

手順

Step 1: Prepare Your Data

Create an Excel spreadsheet with columns for First Name, Last Name, Address, City, State, ZIP. Each row represents one label. Save the file.

Step 2: Open Labels Template

In Word, click Mailings > Labels. Choose your label template (e.g., Avery 5160 for standard address labels). Click OK.

Step 3: Start Mail Merge

Click Mailings > Start Mail Merge > Labels. Select the label size matching your physical labels.

Step 4: Select Data Source

Click Mailings > Select Recipients > Use Existing List. Browse and select your prepared Excel file.

Step 5: Insert Merge Fields

In the label template, position your cursor where you want the first field. Click Mailings > Insert Merge Field. Select Address fields (First Name, Last Name, etc.).

Step 6: Complete Merge

Click Mailings > Finish & Merge > Merge to New Document. Word creates a document with all labels populated with your data.

よくある間違い

• Not preparing data properly—ensure columns match merge field names exactly
• Selecting the wrong label size, causing misalignment when printing
• Forgetting to set up proper spacing and line breaks between address components

ヒントとコツ

• Always test with a few labels on actual label stock before printing hundreds
• Use proper line breaks (Shift+Enter) between address components for professional appearance
• Save your mail merge template for future use—you can reuse it with different data sources