How to print address labels from Excel

Before starting the mail merge process, organize your Excel spreadsheet properly. Create columns with clear headers like "First Name," "Last Name," "Address," "City," "State," and "ZIP Code." Ensure each row contains one complete address and remove any empty rows between data entries.

Clean up your data by checking for typos, inconsistent formatting, and missing information. Word's mail merge feature works best when your Excel data is consistent and properly formatted. Save your Excel file in a location you can easily access from Word.

Avery templates are the most widely used label formats in Word. Common options include Avery 5160 (1" x 2⅝" address labels), Avery 5162 (1⅓" x 4" address labels), and Avery 8160 (1" x 2⅝" laser labels). If you're using a different brand, look for the equivalent size dimensions.

When selecting your template, match it exactly to your physical label sheets. Using the wrong template will cause alignment issues and waste label sheets. If your specific label isn't listed, you can create a custom label by clicking "New Label" and entering the dimensions from your label package.

Click in the first label area and begin inserting merge fields. Use the "Insert Merge Field" button to add fields like "First_Name," "Last_Name," and "Address." Type spaces and punctuation between fields as needed. A typical address label format would be:

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

After formatting the first label, click "Update Labels" to copy this format to all labels on the sheet. This ensures every label will have the same layout and formatting when you complete the merge.

Before printing, preview your labels by clicking "Preview Results" in the Mailings tab. This shows how your actual data will appear on the labels. Use the navigation arrows to scroll through different records and check for formatting issues.

When satisfied with the preview, click "Finish & Merge" and select "Print Documents." Choose whether to print all records, the current record, or a specific range. This is helpful when you only need labels for certain addresses or want to print a test batch first.

If you're using Google Sheets instead of Excel, download your spreadsheet as a CSV file (File > Download > Comma-separated values). You can then use this CSV file as your data source in Word's mail merge process, following the same steps outlined above.

Alternatively, use Google Docs with the "Avery Label Merge" add-on. This free add-on connects directly to Google Sheets and offers many popular Avery templates. Install it from the Add-ons menu in Google Docs, select your sheet and template, then follow the merge wizard.

If labels print with alignment problems, check your printer settings match your label dimensions exactly. Some printers have specific paper type settings for labels that improve accuracy. Always use the manual feed or bypass tray for label sheets when possible.

For data connection issues, ensure your Excel file isn't open in Excel while trying to connect from Word. Close Excel completely, then retry the data source connection. If certain fields appear blank, verify the column headers in Excel match exactly what Word is expecting, including spelling and spacing.