UPC EAN Barcode Labels using Microsoft Publisher Mail Merge

Create UPCEAN barcode labels using Microsoft Publisher Mail Merge.

  • This tutorial shows how to create UPC-A barcode labels in Publisher
  • The barcode data is based on an Excel spreadsheet.
Create UPC EAN barcode labels using Microsoft Publisher Mail Merge Feature

Step 1: Prepare Source of Data in Excel

  • In this example, we use a simple Excel items sheet.
Prepare data source for conversion to BarcodeWiz UPCEAN barcodes
  • Click on UPC EAN Options under the Add-ins tab.
  • Set the Barcode type to UPC-A and click OK.
BarCodeWiz UPC EAN Barcode Fonts Excel Add-In options.
  • Convert the barcode column of the items table using the Selection To Barcodes button in the Add-ins tab.
  • Save the Excel workbook.
Selection to Barcodes, Convert the barcode column of items table using the Selection To barcodes button in the Add-ins tab.

Step 2. Switch to Microsoft Publisher and select label format

  • Select Avery 5160 Easy Peel Address Labels and click CREATE
Generate sequential numbers

Step 3. Select data source

  • Click on Select Recipients under the Mailings tab, and select Use an Existing List.
Generate sequential numbers

  • Select the Excel file we prepared in Step 1 of this tutorial and click Open.
Generate sequential numbers

  • Select the sheet and click OK.
Generate sequential numbers

  • Click OK. again.
Generate sequential numbers

Step 4. Insert, resize, and position the fields.

  • Under the Mailings tab, select Insert Merge Field and select the fields.
Generate sequential numbers
  • Select the item_barcode field and navigate to the Home tab and change the font name and size.
  • Note: the font name should be the same as the font originally used when preparing the barcode data in Excel.
  • Note: The font size alters the size of the barcode. Use the font size at own discretion and always leave extra space around the barcode.
Chang font to BarcodeWiz BCW_UPCEAN_1 and set Font Size to 24

Step 5. Finalize and Preview

  • Under the Mailings tab, select Preview Results to inspect the barcodes.
BarCodeWiz UPC EAN Barcode Fonts mailings tab preview processed barcodes
  • Select Finish & Merge and click on Merge to Printer.
Merge UPC EAN Barcodes in Microsoft Publisher

Step 6. Print the barcode labels

  • Select desired print settings. In this example we are simply printing all the barcodes from the Excel sheet.
Print BarCodeWiz UPC EAN Barcode font labels using desired print settings
  • The final result, using Printer XPS output.
BarCodeWiz UPC EAN Barcode Fonts XPS Printer Output