Auto Generate QR Codes with Data Merge in InDesign CC 2014
Auto Generate QR Codes with Data Merge in InDesign CC 2014
The Data Merge function in InDesign is a powerful, versatile tool for integrated marketing. We use it for variable data printing to personalize individual pieces – text and images – and, if a direct mail piece, to address and barcode for delivery to the USPS. The latest enhancement to Data Merge is the ability to integrate automatically generated QR codes into the Data Merge workflow. The best part is InDesign does almost all the work.
As you may know, InDesign CC will automatically generate a QR code within a document.
Choose Object – Generate QR Code. From the Content tab, you can choose which of 5 main classes of QR code information you want to create: Text, Website, Text Message, Email or Business Card/Contact Information. The Color tab will let you change the QR code from standard Black to one of your other Swatch colors. When you click OK, the code loads onto your cursor for placement (or if you already selected a placeholder box, it places itself on the page). It can be resized to any dimension needed and is a high fidelity graphic object – in other words, it behaves just like a vector piece of artwork.To automatically generated MULTIPLE QR codes through a Data Merge, the key lies in correctly entering the data in your Data Source .csv or .txt file. You will need to create a column (in Excel for example) and – this is the important part – name the column beginning with a hashtag (for example, "#QRcodes"). Within that column you can mix and match any of the 5 types of codes, but the data entries must be in the following formats:
- For plain text: simple, just enter the text you want to be encoded.
- For an SMS Text Message: SMSTO:
: Example: SMSTO:8285551919:Call me! - For a Website Hyperlink: URL:
Example: URL:http://www.imagesmith.com - For and Email Message: MATMSG:\nTo:
\nSUB: Example: MATMSG:\nTo:name@gmail.com\nSUB:Your Subject;\nBODY:;;bodyofemail;\nBODY:;; - For Contact or Business Card Info: BEGIN:VCARD\nVERSION:2.1\nN:
; \nFN: \nORG: \nTITLE: \nTEL;CELL: \nTEL;WORK;VOICE: | \nADR;WORK:;;; ; ; ; \nEMAIL;WORK;INTERNET: \nURL: \nEND:VCARD
Finally, merge your document either by choosing "Create Merged Document" (which will give you a multi-page InDesign document) or "Export to PDF" (which creates the finished multi-page PDF file). If your InDesign document is a 2-pager and you have an .txt or .csv file of 100 entries linked, you will create a 200 page PDF file.