Macro to Bulk Import vCards into Outlook
Last reviewed on June 12, 2012
Microsoft Outlook does not support importing multiple vCards – you need to import them one vcard at a time. While this is tolerable for a few, its frustrating when you a large number to import.
This can also be done using VBA, basically automating the process you’d use to do it manually: open each contact, save in your default Contacts folder then close it. Unless you are Superman, the macro will finish long before you would.
Begin by creating a folder named vcards on root of the c:\ drive. The path will be c:\vcards. Copy all your individual vCard files (.vcf) to this folder.
Next open Outlook and press ALT + F11 to open the VBA editor.
Go to Tools, References and select Microsoft Scripting Runtime and Windows Script Host Object Model from the list and place checks in the box next to each and click OK.
Click Insert, Module and copy and paste the following code into the blank module. Save and run the macro to automatically import and save all the individual files into Outlook.