Create barcode labels in a Word Merge report

You can produce a report of barcode labels with our template.

Before you begin

Download and install a free barcode font such as 3 of 9 Barcode Font.

Step 1. Download the barcode report template

This Word Macro-Enabled Template contains the fields and layout for your barcode labels.

Vernon Systems barcode report template (.dotm)

Step 2. Format the barcode font

  1. Open the template in Microsoft Word.

  2. Select the large placeholder text that says «System_ID».

  3. Change the font to the barcode font that you installed.

Step 3. Save the template on your shared drive

  1. Go to File > Save as.

  2. Select a folder location to save your template. It should be somewhere everyone at your organisation can access, like a shared drive. You can also save report templates to the Wincoll > Reports folder.

  3. Save the template as a Word Macro-Enabled Template (.dotm).

    • Selecting this option may move you to the Custom Office Template folder. Make sure you are in the folder location that you chose in step 2.

Step 4. Save the template in Vernon CMS

  1. Open Vernon CMS and click Report on the toolbar, then select Object.

  2. On the Edit Report Template tab, under Report Types, select Word Merge.

  3. Click Formatting Options.

  4. Select Use Existing Merge Layout Document.

  5. Click into the Document Filename field and click on the folder icon.

  6. Find your template, select it, and click Open. Then click OK.

    • If your template does not appear in the folder you saved it to, your File Explorer may be set to Word Documents. Change it to Document Templates.

  7. Click Save Template and save your template in Portfolio.

Step 5. Run the report

You can now select your records and create a set of barcode labels with this saved report template. Everyone who wants to use this template must have the barcode font installed on their computer.

  1. In Vernon CMS, select your records.

  2. Click Report on the toolbar.

  3. Open your barcode template. It may be in the list of Recent Templates or click More Templates to select it from Portfolio.

  4. Click Run Report and then click Screen. Your report template will open in Microsoft Word.

  5. In Word, go to View > Macros > View Macros.

  6. In the Macros window, select VSL Produce Report and click Run. Your report of barcodes will be generated.

Video

See also

Explainer: Barcodes (Vernon Systems blog)