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
![](https://media.barcodewiz.com/images/0f2e8f50-eb0d-4399-9311-67024f962cc1-UPCEAN-PUBLISHER-thumb.png)
Step 1: Prepare Source of Data in Excel
- In this example, we use a simple Excel items sheet.
![](https://media.barcodewiz.com/images/febe29e4-f52c-45cb-80e0-bcf057891b2a-pub_1.png)
- Click on UPC EAN Options under the Add-ins tab.
- Set the Barcode type to UPC-A and click OK.
![](https://media.barcodewiz.com/images/89eae43a-66a8-45da-9b34-75eca59ba723-pub_2.png)
- Convert the barcode column of the items table using the Selection To Barcodes button in the Add-ins tab.
- Save the Excel workbook.
![](https://media.barcodewiz.com/images/4214119c-3f00-4ee7-b620-32c84379b1e3-pub_3.png)
Step 2. Switch to Microsoft Publisher and select label format
- Select Avery 5160 Easy Peel Address Labels and click CREATE
![](https://media.barcodewiz.com/images/c006b389-c797-4903-8ec8-d2e3c0bab810-pub_4.png)
Step 3. Select data source
- Click on Select Recipients under the Mailings tab, and select Use an Existing List.
![](https://media.barcodewiz.com/images/eb39041b-587c-4203-a062-6978d6e272d0-pub_5.png)
- Select the Excel file we prepared in Step 1 of this tutorial and click Open.
![](https://media.barcodewiz.com/images/cc7a09ee-45f4-4a78-85aa-d6ca4751526f-pub_6.png)
- Select the sheet and click OK.
![](https://media.barcodewiz.com/images/10663c3b-6417-4aa7-8f92-f9f9212032be-pub_7.png)
- Click OK. again.
![](https://media.barcodewiz.com/images/674f7f8f-02db-4670-97b2-20d487316560-pub_8.png)
Step 4. Insert, resize, and position the fields.
- Under the Mailings tab, select Insert Merge Field and select the fields.
![](https://media.barcodewiz.com/images/0dc00ab1-7aad-4f2f-b5e6-0e262ed99c99-pub_9.png)
- 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.
![](https://media.barcodewiz.com/images/fb9a03c6-0998-4e70-9689-06017dbc2ba2-pub_10.png)
Step 5. Finalize and Preview
- Under the Mailings tab, select Preview Results to inspect the barcodes.
![](https://media.barcodewiz.com/images/5967786e-2e61-404d-b5dc-0a5e0aba27e3-pub_11.png)
- Select Finish & Merge and click on Merge to Printer.
![](https://media.barcodewiz.com/images/5eb1e253-16f4-475d-a96a-dc328cb74cff-pub_12.png)
Step 6. Print the barcode labels
- Select desired print settings. In this example we are simply printing all the barcodes from the Excel sheet.
![](https://media.barcodewiz.com/images/acfc8b95-3fdd-404a-90d1-a8ddb8052747-pub_13.png)
- The final result, using Printer XPS output.
![](https://media.barcodewiz.com/images/735c0190-938d-42f0-9690-83a6c41c616a-pub_14.png)