If you want to print a large number of unique QR Codes on labels you may want use the label merge function of Microsoft Office Word. This tutorial guides you how to import a list of QR Codes from an Excel file into a Word template before printing the labels or export them to a print-ready Adobe Pdf file.

Templates for Label Printing

There are various suppliers that provide templates for label printing. Download for example the following template from Herma:

QR Code Import

If you have an account at qrd.by export your QR Codes in a .csv file from the menu “Export” => “Export QR Codes”. If you don’t have an account just download the following example .csv file to work with in this tutorial:

Now open the Word template you have just downloaded and initialize the label merge by clicking the ribbon “Mailings” and the click on “Labels” from the menu “Start Mail Merge”. As soon a dialog pops up click on “Cancel”.

In the next step import the Excel file you have downloaded by clicking “Use an Existing List” from the menu “Select Recipients”:

How to insert a QR Code in a Label

Now set the cursor to the first position in the template. You have to do the following steps manually, otherwise it will not work. Do NOT just copy & paste:

• Press STRG + F9 and 2 braces will appear. Now enter the keyword INCLUDEPICTURE in between
• Press STRG + F9 again and insert IF TRUE
• Press STRG + F9 another time and insert MERGEFIELD followed by the column name of the .csv file containing the links to the QR Codes (in the example file the name is qrcode)
• Now set the cursor before the last brace und insert \d

 

After initializing the first label deploy the QR Codes to all labels by clicking “Update Labels”:

Now click on “Preview Results” to finalize the import of the QR Codes:

 

Batch Printing

To print the labels just click on “Print Documents” from the menu “Finish & Merge”:

As an alternative you can also save the document as a .pdf file by printing to the “Microsoft Print to PDF” in the Print dialog box. You can download an example .pdf file here:

With our Batch QR Code Generator you can create up to 1.000 QR Codes. If you need a higher volume just get in contact with us.

Appendix: Layout in a Label with mixed content

You can also add any other column of the Excel file into the label. Just press STRG + F9 insert MERGEFIELD followed by the column name, e.g. { MERGEFIELD id }

If you plan to display more fields than just the QR Code on a label use tables for layouting. For example, create a 2×2 table and merge the two cells at the bottom. Insert the QR Code in the first cell, add a hint in the second cell and add the shortened URL in the merged cell at the bottom. You can control the size of a QR Code by changing the width of the first cell. Click on the image below to download a word template with a layout a shown in the picture:

 

Further Tips for printing QR Codes

• Tips for QR Code Printing

• Minimum Size of a QR Code

• Label Templates from Herma

• How to sort QR Codes for printing