Barcodes in MS Publisher Mail Merge
Create Code 128 barcode labels in MS Publisher Mail Merge
- In this tutorial, we will show you how to create Code 128 barcodes in Publisher based on data from an Excel table.
- Follow the steps below, or watch the tutorial.
![](https://media.barcodewiz.com/images/98b20553-1155-485d-91b3-64d44748e2ab-C128-publisher-001.png)
Step 1: Prepare Source of Data
- In this example, we use a simple excel items table.
![](https://media.barcodewiz.com/images/42d682f7-66ad-4311-ae4a-61f62f36571c-pub_1.png)
- Click on Code 128 Options under the Add-ins tab.
- Set the Barcode type to Code128B and click OK.
![](https://media.barcodewiz.com/images/0e59dd9f-37aa-406b-a0e3-02c3e9aea369-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/b5077f45-9c22-4b27-a7eb-dcfc0bc50cdb-pub_3.png)
Step 2. Switch to Microsoft Publisher and select label format
- Select Avery 5160 as the template and click CREATE
![](https://media.barcodewiz.com/images/892318c2-6469-4c63-97d3-41718b632192-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/190a1941-bd3a-4301-a126-b3a59239ee94-pub_5.png)
- Select the Excel file (Items.xlsx) file we prepared in Step 1 of this tutorial and click Open.
![](https://media.barcodewiz.com/images/15ce2724-f0ea-404f-872c-277922273182-pub_6.png)
- Click OK with the worksheet selected.
![](https://media.barcodewiz.com/images/ad4083f0-405c-480b-9009-9bc5dbe7b444-pub_7.png)
- Click OK again.
![](https://media.barcodewiz.com/images/213ec427-4400-4729-b0a7-645d4c05cc0d-pub_8.png)
Step 4. Insert, resize, and position the fields.
- Under the Mailings tab, select Insert Merge Field and select our data fields.
![](https://media.barcodewiz.com/images/7d314342-7946-4ba9-9845-c5f1e93b3065-pub_9.png)
- Select the item_barcode field and change its 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 point size alters the size of the barcode.
![](https://media.barcodewiz.com/images/b2fa0cff-632f-486c-9f63-fe9776895da0-pub_10.png)
Step 5. Finalize and Preview
- Under the Mailings tab, select Preview Results to visually inspect that the barcodes.
The > arrow can be used to cycle through the items of the data source.
![](https://media.barcodewiz.com/images/c7954af1-242e-4790-9e29-ac900e620a9f-pub_11.png)
- Next, under the Mailings tab select Finish & Merge and click on Merge to Printer.
![](https://media.barcodewiz.com/images/79519b2e-6923-4fb9-99c4-8918f4e4db54-pub_12.png)
Step 6. Print the barcode labels
- Select desired print settings.
In this example we are simply printing all five barcodes from the items data source.
![](https://media.barcodewiz.com/images/2bbb4a68-fc8c-4bf9-bf1f-300b3837897d-pub_13.png)
- The final result, using Printer XPS output.
![](https://media.barcodewiz.com/images/1c8e9340-7aed-401a-be7b-1037cb304840-pub_14.png)