BarCodeWiz Logo

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.

Step 1. Import Excel data

  • Click on Data Table > Import Excel Spreadsheet
Click on Import Excel Spreadsheet to import Excel data
  • Browse for your Excel file.
Browse for your Excel file
  • Preview file contents and click OK.
Preview contents of imported Excel file and click OK to confirm the import

Step 2. Insert a Barcode Control

  • Select desired barcode type.
Select Symbology from the drop-down list, by clicking on the Barcode button

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
  • 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
  • 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

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