Barcode labels in MS Word 2016, 2013, 2010, or 2007 Mail Merge

Barcodes in Excel

Barcodes in Word

Barcodes in Access

More Tutorials

User Manual

  • This tutorial shows how to create barcode labels in MS Word Mail Merge.

Step 1. Start Mail Merge

  • Open the Mailings tab and click on Start Mail Merge > Labels...

Step 2. Select Label

  • Select the label format you would like to use. We are using Avery 5163 Shipping Labels here.

Step 3. Select data for the label

  • Click on Select Recipients > Use Existing List and select the Excel file you would like to use.
  • Select the Excel file
  • Click OK to open Sheet1 (the default setting here).

Step 4. Insert Fields

  • Insert the merge items into the top-left label, as shown.

Step 5. Add Brackets around barcode fields(s)

  • Surround the barcode text field with square brackets.
  • Any text field surrounded with brackets will be converted to barcodes.

Step 6. Copy data to all other labels

  • Click on Update Labels to copy the fields into the other labels on the page.
  • To center, click Ctrl+A followed by Ctrl+E..

Step 7. Complete the Merge

  • Open the Add-Ins tab and click on Convert All to finish the Mail Merge and create the barcodes.
  • Barcode labels are created in a new document. You may print or save the document now.