Create Mail Merge Barcodes
Create Mail Merge Barcodes using BarCodeWiz OnLabel
- This tutorial shows how to create barcode labels using Excel data.
- Follow the steps below, or simply watch the video.
![](https://media.barcodewiz.com/images/39187c13-0923-4748-b37b-dd0776289c36-onlabel24.png)
Step 1. Import Excel data
- Click on Data Table > Import Excel Spreadsheet
![Click on Import Excel Spreadsheet to import Excel data](https://media.barcodewiz.com/images/87479007-0813-4a12-9f4a-3081f0400a2e-onlabel16.png)
- Browse for your Excel file.
![Browse for your Excel file](https://media.barcodewiz.com/images/2f6b5943-9d99-469a-b444-8e7bb69b37ad-onlabel15.png)
- Preview file contents and click OK.
![Preview contents of imported Excel file and click OK to confirm the import](https://media.barcodewiz.com/images/4c90bf75-c1a3-4242-adb7-a1a071374946-onlabel17.png)
Step 2. Insert a Barcode Control
- Select desired barcode type.
![Select Symbology from the drop-down list, by clicking on the Barcode button](https://media.barcodewiz.com/images/3cbbe562-ee23-4515-b80d-4d3f8bbb43d1-onlabel18.png)
Step 3. Bind your data to the barcode control
- Drag the column heading onto the barcode.
![Bind the data column to the barcode by dragging it onto the barcode](https://media.barcodewiz.com/images/99425df5-0214-43a5-9d43-10bda833f3f5-onlabel19.png)
- Drop the column heading onto the barcode.
- This binds (connects) the column values to the barcode
![Drop the column heading onto the barcode. This binds (connects) the column values to the barcode](https://media.barcodewiz.com/images/47df2d71-427c-4313-ab23-038acdfb2dd7-onlabel20.png)
- Drop the other columns on the label to create bound text.
- Position the fields in the label
![Drop the other columns on the label to create bound text. Position the fields in the label](https://media.barcodewiz.com/images/64f0dd50-0618-4654-826d-866a72f16cf3-onlabel22.png)
That's it! You are ready to print.
- Go to File > Print
- Select the labels and click Print.
![Select Data Merge, All Records, and set Specify Quantity to one to print the labels using data in your table, one copy of each](https://media.barcodewiz.com/images/6ef77a08-e95b-4e1d-8aed-57474c8a0718-onlabel23.png)