Create Barcode Labels with Mail Merge
Create Code 39 barcode labels using data from Excel or another source (text files, databases, Outlook, and others).
![](https://media.barcodewiz.com/images/7aefdacf-fc74-458d-960e-f009a09c8091-code39_word_mailmerge8.png)
Step 1. Open the Labels wizard
- Open the Mailings tab and click on Start Mail Merge > Labels
![](https://media.barcodewiz.com/images/056b9b9c-2325-4b8f-938f-767da79ae22b-code39_word_mailmerge1.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/64818ee1-3f38-44b3-85cc-3270cc4d110d-code39_word_mailmerge2.png)
Step 3. Select Source of Data
- Click on Select Recipients > Use Existing List
![](https://media.barcodewiz.com/images/6f85294d-84bc-4555-80ed-d5f33bccee4a-code39_word_mailmerge3.1.png)
- Select the Excel file you would like to use.
![](https://media.barcodewiz.com/images/17c1166f-06e9-42f6-9f34-eee4f0b59911-code39_word_mailmerge3.2.png)
- Click OK to open Sheet1 (the default setting here).
![](https://media.barcodewiz.com/images/451fea49-685a-43b8-98e2-70559179f48d-code39_word_mailmerge4.png)
Step 4. Insert and position the fields
- Insert the merge items into the top-left label, as shown.
![](https://media.barcodewiz.com/images/a6679ca3-0af5-4081-b4e9-327e71c932d5-code39_word_mailmerge5.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/f9e3e2d7-38fa-45d4-a67d-58f7f1dd9940-code39_word_mailmerge6.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/6cb0b201-c7bb-40e0-8f5e-c5b4e07f4d85-code39_word_mailmerge7.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/7aefdacf-fc74-458d-960e-f009a09c8091-code39_word_mailmerge8.png)