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:
Word template for printing QR Code labels
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:
Example .csv Excel for QR Code Labels
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
INCLUDEPICTUREin between - Press CTRL + F9 again and insert
IF TRUE - Press CTRL + F9 another time and insert
MERGEFIELDfollowed 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:
Hello,
I have a questions regards your QR creator tool. Is it possible to mass-produce, personalised QR codes, each with a different link, and that can also incorporate a small in-house code/text (so that we know which QR is which!). Is this possible?
Thanks for your help
Matt
Hello Matt,
I’m Jordi Hernandez, Professional Services Manager at qrd.by.
Yes, you can mass produce dynamic QR Codes with color and an embeded logo if you wish. A small label with the name/code of the QR Code can also be added as part of the image too.
You can test our solution for 30 days (no credit cards required)
https://qrd.by/features
https://qrd.by/batch-qr-codes
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.