Create Barcode Labels with Mail Merge
Create Code 128 barcode labels using data from Excel or another source (text files, databases, Outlook, and others).
![](https://media.barcodewiz.com/images/53e207c0-1ce7-41f7-adf0-ca9f93f0aede-wordmailmerge0.png)
Step 1. Open the Labels wizard
- Open the Mailings tab and click on Start Mail Merge > Labels
![](https://media.barcodewiz.com/images/bac913e7-a32e-489f-8fba-5b864e934590-wordmailmerge1.png)
Step 2. Select label format
- Select the label format you would like to use. We are using Avery 5163 Shipping Labels here.
![](https://media.barcodewiz.com/images/eedd7c3e-f3cc-484a-a33d-7428519f43a0-wordmailmerge8.png)
Step 3. Select Source of Data
- Click on Select Recipients > Use Existing List
![](https://media.barcodewiz.com/images/68b01bd1-590c-4853-8c74-d4f898c99f31-wordmailmerge9.png)
- Select the Excel file you would like to use.
![](https://media.barcodewiz.com/images/47d960f0-632f-4f65-9c99-0e73a2d273eb-wordmailmerge2.png)
- Click OK to open Sheet1 (the default setting here).
![](https://media.barcodewiz.com/images/22aa889e-5578-4c14-96d3-ac4181efeb3c-wordmailmerge3.png)
Step 4. Insert and position the fields
- Insert the merge items into the top-left label, as shown.
![](https://media.barcodewiz.com/images/f85e9448-6e94-47e5-8ceb-bbf6a9335682-wordmailmerge4.png)
Step 5. Add brackets around the data
- Put brackets around any text field you wish to convert to barcodes. In this example, the Barcode text field in each label will be converted into a barcode. The other fields will remain unchanged.
![](https://media.barcodewiz.com/images/9b0fde5d-41da-473c-8f31-f91c02cb3d8e-wordmailmerge5.png)
Step 6. Update and position 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
![](https://media.barcodewiz.com/images/82e6a8a8-4162-44c2-ac18-d2bb50b9455b-wordmailmerge6.png)
Step 7. Convert All
- 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.
![](https://media.barcodewiz.com/images/8f19d1f5-6eb0-4a66-8df5-da7ecfd0cf4b-wordmailmerge7.png)