{"id":14285,"date":"2017-10-08T00:52:30","date_gmt":"2017-10-08T00:52:30","guid":{"rendered":"http:\/\/learnexcelmacro.com\/wp\/?p=14285"},"modified":"2022-08-09T20:08:26","modified_gmt":"2022-08-09T20:08:26","slug":"excel-to-vcard-converter-tool","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2017\/10\/excel-to-vcard-converter-tool\/","title":{"rendered":"VBA to Convert Contact Data in Excel to VCF format"},"content":{"rendered":"
[et_pb_section fb_built=”1″ _builder_version=”4.17.6″ hover_enabled=”0″ da_disable_devices=”off|off|off” global_colors_info=”{}” custom_padding=”0px||||false|false” sticky_enabled=”0″ da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”0px||||false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.17.6″ custom_padding=”||||false|false” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ global_colors_info=”{}” custom_padding=”0px||||false|false” sticky_enabled=”0″]<\/p>\n
Dear Friends,<\/p>\n
As you have learned about interacting with Text files through Excel VBA<\/a>, it is time to see the usage of those methods you learned. One usage, you have already seen here, in how to export excel data in CSV format.<\/a> Don’t worry… this is nothing new. You have always been using this file indirectly. Sample Structure of vCard or VCF file<\/strong><\/p>\n Here is a sample vCard file. Each contact details are stored within
In this article, I am going to teach you how to Export contacts stored in an Excel table as the vcf file format. This is also called a vCard file. In other words, VBA to convert Contact details from Excel to Mobile Contact format.
Before we go on discussing the technical implementation of it, let’s understand – What is the VCF file format? What is its use of it? How are this article and code going to help you?<\/p>\n<\/div>\n<\/i> What is VCF or vCard File ?<\/h1>\n
It is an abbreviation of V<\/strong>irtual C<\/strong>ontact F<\/strong>ile. Basically, this is Text type file which stores the contacts which you use in Outlook, mobile etc. That is why, I said.. you have always been using this file directly or inderectly.
It is also known as vCard (Virtual Card) file. Extension for this file type is .vcf or .vcard
As I mentioned above, this is simple text file but all the details of a contacts are written in a specific format.<\/p>\nBEGIN:VCARD<\/code> and
END:VCARD<\/code> tags as shown below:<\/p>\n