How To Create Contacts Vcf File From Excel -

He needed a —a virtual business card file that phones understand. But how do you turn rows of text into digital contacts?

Within seconds, all 300 parents were in his phone. He typed his group text, pasted the auction link, and hit send. how to create contacts vcf file from excel

He realized a VCF file is just plain text with a special format. He added a new column called VCF_Formula . In cell E2, he typed this magic spell: He needed a —a virtual business card file

="BEGIN:VCARD"&CHAR(10)&"VERSION:3.0"&CHAR(10)&"FN:"&A2&" "&B2&CHAR(10)&"TEL:"&C2&CHAR(10)&"EMAIL:"&D2&CHAR(10)&"END:VCARD" pasted the auction link

His job? Send a text blast with the auction link.