As of 2023, January, I'd recommend using this code: =CONCATENATE("BEGIN:VCARD VERSION:4.0 N:",B2,";",A2," FN:",A2," ",B2," TITLE:",C2," TEL;WORK;VOICE;PREF:",D2," EMAIL;WORK:",E2," ORG:",F2," END:VCARD") In order to get the cell to fill in the details from the other cells, you need that Concatenate command, and wording outside of that needs quotation marks, and in addition to the fn Full Name, you need a regular Name that needs to be last;first. If you put that into the top part, it will fill in the details, and you can copy that field to automatically fill in from other fields. Also, you need to save a regular Workbook file and then Save-As to the CSV. If you just save it as a CSV, it will lose the Concatenation. Wiki for details: en.wikipedia.org/wiki/VCard Good luck!
thank you very useful video, please tell me, in 13:01, do i need to create a QR code script for every person or there's someway to generate automatically? Best
@@ShinyDice If you want to generate a QR code from an url only just replace the whole Vcard structure with the url. Make sure to include or as well. And make sure the column itself uses the #QR name. Indesign generates them automatically, no need for an additional plugin.
amazing video! so much useful i subscribed :D can you PLZ tell me: how to print on both pages. like i want to print on an A4 page, multiple cards in same pages, and also i want to print the back part of the cards in the back part of page accordingly. so after cutting, i want to get cards that have things printed on both sides of the paper
Watch the video from 13:38 onwards and you'll see that there is a brief explanation of how to format the data for a QR code. Check Wikipedia for more information if required.
![How to Set Up Numbered Tickets in Adobe InDesign So They'll Cut in Order [Data Merge]](http://i.ytimg.com/vi/kaV2A0jVTc8/mqdefault.jpg)
![“อ.เบียร์ คนตื่นธรรม” มาตามคำเรียกร้อง แหกศาสตร์ฮวงจุ้ย เตือนสติอย่างมงาย | แฉ 7 พ.ย. 67 [1/3]](http://i.ytimg.com/vi/5fc4S3xBNfc/mqdefault.jpg)
how you put data qr in excel file ?
I didn't get how you get the QR list, could you please explain?
Very very useful information thank you dojo for sharing your knowledge. Have a great day. Peace
Thank you so much man, i appreciate your video, you helped me a lot.
I got how your create #QR code but did you annual change those data's can't we generate each QR code BEGIN code automatically from our data?
VAYA!!!! AT LAST!!!! YOU ARE MY HERO
Great video, thanks bro !
As of 2023, January, I'd recommend using this code:
=CONCATENATE("BEGIN:VCARD
VERSION:4.0
N:",B2,";",A2,"
FN:",A2," ",B2,"
TITLE:",C2,"
TEL;WORK;VOICE;PREF:",D2,"
EMAIL;WORK:",E2,"
ORG:",F2,"
END:VCARD")
In order to get the cell to fill in the details from the other cells, you need that Concatenate command, and wording outside of that needs quotation marks, and in addition to the fn Full Name, you need a regular Name that needs to be last;first.
If you put that into the top part, it will fill in the details, and you can copy that field to automatically fill in from other fields.
Also, you need to save a regular Workbook file and then Save-As to the CSV. If you just save it as a CSV, it will lose the Concatenation.
Wiki for details: en.wikipedia.org/wiki/VCard
Good luck!
Quite good explaied for beginner.
I Would like to know what is the abbreviation for JOB TITLE
Hello, I hope to get an answer here. is it possible to have the same thing for facebook social networks for example ?
Loved it... Thank you so much
A VERY USEFUL! THANKS!
subscribed!
Thank you so much for this information 😍
how would you add a back side of card?
This is AWESOME! Is there anyway to do something similar to this in Illustrator? That is where my current template is located.
Short answer is no. But you can always place your Illustrator design onto a master page in InDesign.
Thank You
Nice work
Thank you so much for such an excellent tutorial. Could you please leave the link to Wikipedia for the codes?
I wanted to know the same thing. Were you able to find it? Thanks!
Just go to; en.wikipedia.org/wiki/VCard it lists all the available vcard properties.
great Vidoe Tony
Awesome!!!
thank you very useful video, please tell me, in 13:01, do i need to create a QR code script for every person or there's someway to generate automatically? Best
and please also if possible to put only an url 9website) in the qr code script
@@ShinyDice If you want to generate a QR code from an url only just replace the whole Vcard structure with the url. Make sure to include or as well. And make sure the column itself uses the #QR name. Indesign generates them automatically, no need for an additional plugin.
@@pendaco i think tha he asking for the way the autor generate the #QR sexion. Manualy ou automaticaly?
THANKS
amazing video! so much useful
i subscribed :D
can you PLZ tell me:
how to print on both pages. like i want to print on an A4 page, multiple cards in same pages, and also i want to print the back part of the cards in the back part of page accordingly.
so after cutting, i want to get cards that have things printed on both sides of the paper
You didn't explain how you generated the data in the #QR column.
Watch the video from 13:38 onwards and you'll see that there is a brief explanation of how to format the data for a QR code. Check Wikipedia for more information if required.
@@TheDesignNinja Do you do it manualy?
wonderfull
BACSIC V CARD EXPLAINED . PLS MAKE QR CODE DATE MANUL OR AUTOMATIC GENERATOR
You gave little to no info on how the QR column is generated in the excel list, rendering this tutorial useless.