Tutorial: Creating barcode labels with Microsoft Word Mail Merge

Using Morovia barcode fonts and included VBA module, you can easily create barcode labels. The linear font VBA module provides encoding functions for the following barcode formats: Code 39, UPC-A, UPC-E, EAN-13, EAN-8, Code 93, Code128, EAN-128, Codabar, POSTNET, Royal Mail, and Interleaved 2 of 5. VBA modules for other types of barcodes are included in the product packages.

This tutorial assumes that you are running a retail store and need to assign UPC-A codes for items that do not have barcode on the box. Generally speaking you can assign UPC codes that started with digit 4 for your own warehouse use. You can find more information at UPC-A Specification.

To follow the steps in this tutorial, you need Morovia UPC/EAN fontware product. You can use the trial version which can be download at here.

Assuming that the item list is store in an Excel spreadsheet, as below:

  1. Step 1. Prepare the data source. Follow the instructions in Tutorial: Using Barcode Fonts in Excel Spreadsheets to import linear barcode font VBA module to Excel.

  2. Step 2. In Microsoft Word, Open the Mailings tab and click on Start Mail MergeLabels...

  3. Step 3. Select the label format you'd like to use. Here we use Avery 5163 Shipping Labels.

  4. Step 4. click on Select RecipientsUse Existing List... Navigate to the spreadsheet we just created.

    click OK to select Sheet1 (the default).

  5. Step 5. click on Insert Merge Field to insert the fields that appear on the label. Layout them accordingly.

  6. Step 6. Highlight barcode field, and choose Font. Change the font to MRV UEBMA, 12 points. Click on Update Labels to transfer the settings to other labels.

  7. Step 7. Click on Preview results to view the merge results. You can print the labels out. If you changed values of some records, added or inserted records, the word document will reflect the changes.