How to create QR code VCARDS using excel macros

Published 2022-09-05

All Comments (21)
  • @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
  • This works! Thanks very much. I just wonder if there is a way to include the address and birthday on the VCF?
  • @vikrant9281
    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.
  • @kanavukadhalan21
    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?
  • @GastonHuot
    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"
  • @kiramarte7316
    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?
  • @mohammedwajid488
    Hello, I really appreciate this i need to add a logo and some color to the border could you please help me with this?
  • @robertgzz
    Great! Thanks! What if I want to add an URL? Birthday? Social profile?
  • @highteene
    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?
  • @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?
  • @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.
  • @bagusc.e9606
    How to automatically fill in vlookup data and take data from several columns into 1 into a QR code
  • @GastonHuot
    First name and Last name (N:) are not in the vCard produced, just the FN: code ... 😢