UPC EAN Barcodes in MS 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.
- Watch the video or follow the steps below
Step 1: Prepare Source of Data in Excel
- In this example, we use a simple Excel items sheet.
- Click on UPC EAN Options under the Add-ins tab.
- Set the Barcode type to UPC-A and click OK.
- Convert the barcode column of the items table using the Selection To Barcodes button in the Add-ins tab.
- Save the Excel workbook.
Step 2. Switch to Microsoft Publisher and select label format
- Select Avery 5160 Easy Peel Address Labels and click CREATE
Step 3. Select data source
- Click on Select Recipients under the Mailings tab, and select Use an Existing List.
- Select the Excel file we prepared in Step 1 of this tutorial and click Open.
- Select the sheet and click OK.
- Click OK. again.
Step 4. Insert, resize, and position the fields.
- Under the Mailings tab, select Insert Merge Field and select the fields.
- 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.
Step 5. Finalize and Preview
- Under the Mailings tab, select Preview Results to inspect the barcodes.
- Select Finish & Merge and click on Merge to Printer.
Step 6. Print the barcode labels
- Select desired print settings. In this example we are simply printing all the barcodes from the Excel sheet.
- The final result, using Printer XPS output.
