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 CTRL + F9 and 2 braces will appear. Now enter the keyword
INCLUDEPICTURE
in between - Press CTRL + F9 again and insert
IF TRUE
- Press CTRL + 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 isqrcode
) - 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 CTRL + 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:
Please use CTRL instead of STRG (that’s German)
Thanks, updated :)
Good Morning,
I have a few questions about QR Code Marketing and would love your insight. My company, HTeaO, is looking into using QR codes for our paper coupons. The reason we are looking into QR codes for our coupons, is that we want to be able to track what store the coupons was used at, and to prevent the “reprinting” and theft of our coupons. We have 100 locations in the works and are looking to make large bulk coupons at once that can be scanned in store for a free beverage and not be used again. Is this possible in the QR Code world, or do you have a better idea of how we can go about this?
Hello Rachel,
your request can be fully managed using our QR based mobile coupon solution
https://qrd.by/qr-code-coupon
Yes, you can create 1-time redeemable codes
Yes, you can control whether they have been redeemed and where they were (GPS based) when they redeemed.
Yes, you can use them in your printed coupons
Moreover, you will be able to distribute digital coupons among your current customers via web, email o social networks, use them as reward for new followers and have a real time report system.
More info about 1 time redeemable vouchers
https://qrd.by/how-to-create-one-time-redeemable-qr-code-coupons
We suggest you sign-up and use our 30 days free trial (no credit cards numbers are necessary) to check out our solution: https://qrd.by/features
Please feel free to contact us if you need further information, we will be glad to guide you through our product.