Create barcode labels with Microsoft Word Mail Merge

Create Code 128 barcode labels using data from Excel or another source (text files, databases, Outlook, and others).

Code 128 barcode labels in Word Mail Merge using data from Excel

Follow these steps to create Code 128 barcode labels with Word Mail Merge.

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

Word Mail Merge - Labels

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

Select your label for barcode layout

Step 3. Click on Select Recipients > Use Existing List and select the Excel file you would like to use.

Select Excel sheet with barcode numbers

Excel spreadsheet with Code 128 barcode numbers

Step 4. Click OK to open Sheet1 (the default setting here).

Select Sheet (use default here)

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

Insert Excel fields into the label

Step 6. Position the fields. Surround the barcode text field with square brackets

Surroung barcode data with square brackets

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

Labels are now formatted, ready to convert to Code 128 barcodes

Step 8. Open the Add-Ins tab and click on Convert All to finish the Mail Merge and create the Code 128 barcodes.
You may print or save the labels now.

Code 128 barcodes on Avery labels in Word