Attached is a spreadsheet to create the string for a QR code only. I use this in a 2 step process.
Things to keep in mind. The vcard code requires BEGIN, VERSION, and END in the code, while having any property (within the specification) you like, such as name, company, url, telephone cell, address, etc. Most devices will only import a few properties from a qr code scan. The more data in code, the larger (in physical size) the code will need to be. So my example uses name, email, organization, website.
Also, the code needs to be separated by line breaks. A datamerge source file cannot accomodate line breaks, but fortunately you can use \n.
The first step is to create the qr code string, this can be done with attached spreadsheet, filling variable information into the yellow columns. Then you need to merge information into one (see bottom of screen shot). This column needs to be integrated into main data source file. And use #qr for the column header.
Second step is the complete datamerge with new data file to merge all text variables along with a qr code.
... View more