Please enable JavaScript to view this site.

Vernon CMS Help

Navigation: Advanced Topics > Advanced Reporting

Barcode label reports

Scroll More

Use our template to produce a report of barcode labels.

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 barcode labels.

Vernon Systems barcode report template (.dotm)

Step 2. Format the barcode font

1.Open the template.

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).

oSelecting 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 in the top toolbar, then select Object.

2.Click Edit Report Template.

3.For the Report Type, select Word Merge, then 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.

oIf 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 on Report in 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.Select VSL Produce Report and click Run. Your report of barcodes will be generated.

See also

Explainer: Barcodes