How to create QR code VCARDS using excel macros

In this tutorial we would learn:
1. How to create a VCARD in QR code format
2. Format of VCF files

[khethangsesoane]

Kindly assist: I get an error '1004', "Unable to get the Insert property of the Pictures Class"

[ma.estilamontines]

This works! Thanks very much. I just wonder if there is a way to include the address and birthday on the VCF?

[amazingpen]

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

[rasulatayev]

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?

[highteene]

How can I add website URL, fax, and address field?

[kanavukadhalan]

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?

[bagusc.e]

How to automatically fill in vlookup data and take data from several columns into 1 into a QR code

[robertgzz]

Great! Thanks! What if I want to add an URL? Birthday? Social profile?

[habebliaquath]

Thank you very much and It is working well. Need to add website in this. Kindly explain.
Thank you.

[kiramarte]

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?

[GastonHuot]

Amazing. Exactly what I was looking for. Would it be possible to add a field for a small Note ?😃

[danieldesousa]

Very good video. Would it be possible to add a line in the code for the addition of a persons picture?

[mohammedwajid]

Hello, I really appreciate this i need to add a logo and some color to the border could you please help me with this?

[miajawilliams]

Is there a copy of the script used for this?

[GastonHuot]

First name and Last name (N:) are not in the vCard produced, just the FN: code ... 😢

[mahmoudkamal]

the QR code Pic is not appears, Even when i copy the entire URl and paste it in the browser, it's shows Error msg "404 Not Found"

[LindaLicari]

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.

[vikrant]

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.

[BadereddineYazid]

Please if you can share the file, thank you