How to create QR code VCARDS using excel macros
18,758
Published 2022-09-05
1. How to create a VCARD in QR code format
2. Format of VCF files
Pre-requisite: • How to Create VCARD (VCF) file from E...
All Comments (21)
-
i had problem, how to add plus sign on phone number?i had add in excel cell but when scan the qr, the plus sign in front of number phone was missing. Please your suggest.Thanks
-
This is great! Thank you!
-
This works! Thanks very much. I just wonder if there is a way to include the address and birthday on the VCF?
-
Bro you are incredible!!
-
HI BUDDY THANKS FOR HELPING RIGHT NOW I AM FACING AN ISSUE THAT I NEED SERIAL NUMBER NEAR THESE QR CODE I SEARCH A LOT BUT NOT ABLE TO FIND ANY SOLUTION YET. CAN YOU HELP ME WITH TAHT.
-
Loved it 😊
-
Hello. Thank you for the video, it was amazing. One problem tho, the QR code saves the vcard with a +44 (UK International) prefix. How to I change or remove that?
-
Amazing. Exactly what I was looking for. Would it be possible to add a field for a small Note ?😃
-
Kindly assist: I get an error '1004', "Unable to get the Insert property of the Pictures Class"
-
i managed to generate the QRs but it seems to generate only empty unreadable QRs. The VCF Text seems correct but the Code isn't scannable. Is there anyone else with this problem or anyone who knows a solution?
-
Hello, I really appreciate this i need to add a logo and some color to the border could you please help me with this?
-
Great! Thanks! What if I want to add an URL? Birthday? Social profile?
-
How can I add website URL, fax, and address field?
-
Very good video. Would it be possible to add a line in the code for the addition of a persons picture?
-
great! thanx a lot. but i have a question, if i put a "+" sign before number (even though i change type to TEXT), QR is not showing +123456, instead it is 123456. which makes vcard useless. what can i do with this?
-
I was super excited to find this video. it is very clear and easy to follow but for the life of me I cannot get it to work. When I scan the QR Code in the spread sheet your work find. when I scan the one you bring up in the browser I get "No Usable Data Found". I also get this when I try to create the URL on my own. I have stripped it down to bare bone with no luck. Any tips would be greatly appreciated. I an also trying to create these using Google Sheets and GAS.
-
How to automatically fill in vlookup data and take data from several columns into 1 into a QR code
-
Is there a copy of the script used for this?
-
Can I do this in google sheets??
-
First name and Last name (N:) are not in the vCard produced, just the FN: code ... 😢