Participating Frequently

Question

VCard with Excel and Data Merge (QR-Code) to txt or csv

Forum|Forum|6 years ago
March 14, 2019
2 replies
14556 views

Hey guys,

I have about 2000 different business cards witch must be updated with a CR-code containing a VCard.

I am already using an excel-sheet with data-merge (Company, Title, FName, LName, Phone, E-Mail, etc.)

I would like to generate an auto-QR-code (VCard) on the business cards by using my excel-sheet and data merge.

The VCard/QRcode must contain these categories:

Company

Title

FName

LName

Phone

E-Mail

I have already added a new column "#CRcodes" but i don't know how to implement the categories correctly.

I have found this from adobe:

BEGIN:VCARD\nVERSION:2.1\nN:Smith;John\nFN:John Smith\nORG:Adobe \nTITLE:Ingenieur\nTEL;CELL:+919876543210\nTEL;WORK;VOICE:123456789\nADR;WORK:;;Straße ABC;Seattle;Washington;98101;USA\nEMAIL;WORK;INTERNET:abc@adobe.com\nURL:www.adobe.com\nEND:VCARD

So I simply tried this - but I guess its for a .txt and not for my excel-sheet:

BEGIN:VCARD\nVERSION:2.1\Company\Title\FName\LName\Phone\E-Mail\nEND:VCARD

I dont know what nVERSION:2.1 means?
Or what the n stands for?

Its a bit complicated i know but i hope somebody can help me out here!

This topic has been closed for replies.

Colin Flashman

Community Expert

Sorry I'm late.

I think I can help. I'd written an article on how to do this over at InDesignSecrets: https://indesignsecrets.com/data-merge-qr-codes-explained.php

The linked article explains that in Adobe's help page for the issue, there's a typo and information that isn't required. The article also explains how to use the concatenate feature in Microsoft Excel, though upon reflection the concatenate feature could just be replaced by using ampersands to join text strings together. Combine text from two or more cells into one cell - Office Support

If the answer wasn't in my post, perhaps it might be on my blog at colecandoo!

JensPassothAuthor

Participating Frequently

Okay thx Guys,

I will try this out this weekend and give a report - and hopefully a solutions

JensPassothAuthor

Participating Frequently

...no solution for this after trying several times.

Alternative: Im generating QR-Codes by typing all info manually

Still... thx for all the help

D

DBLjan

Legend

I found this. You could batch/create the codes upfront, and link into Excel/InDesign as image.

http://goqr.me/api/doc/

D

DBLjan

Legend

https://qrcode.tec-it.com/API/QRCode?data=BEGIN%3aVCARD%0d%0aVERSION%3a2.1%0d%0aN%3aMax+Muster%0d%0aTEL%3bHOME%3bVOICE%3a0043-7252-72720%0d%0aTEL%3bWORK%3bVOICE%3a0043-7252-72720%0d%0aEMAIL%3aemail%40example.com%0d%0aORG%3aTEC-IT%0d%0aURL%3ahttp%3a%2f%2fwww.example.com%0d%0aEND%3aVCARD

Found a better one, whos doing VCARDs also:

Gratis QR-Code Generator. QR-Codes kostenlos online erstellen!

JensPassothAuthor

Participating Frequently

Thx for your answer

Maybe I am getting it wrong but it seems like I would have to input all information 1 by 1 for all Employers.

I have 2000 employers with information already listed in my excel-sheet. Also we have our own business-card-design.

This is why i am looking for a rather easy way to include a QR-code on my master-layout (indesign) and simply import my excel-sheet via data merge.

I don't really want to necessarily input all 2000 employers manually to accomplish a VCard-link on our new business-cards . Would be nice if the QRcode could grab all info (Company, Title, FName, LName, Phone, E-Mail) from my excel-sheet and plop it in via data merge.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded