This small VBA macro automates the import of vCard files from a local folder into Outlook. It loops through all files in C:\VCARDS, opens each one through Outlook, saves the imported contact, and then closes the Inspector window again.
What the macro does
The macro is designed for simple batch import scenarios where multiple .vcf files need to be processed at once. It uses the Outlook Inspectors collection to detect when a vCard has been opened, saves the current item, and then closes the window without keeping additional changes.
How it works
The macro scans the C:\VCARDS folder and opens each vCard file one by one in Outlook. Once Outlook creates the contact window, the script saves the imported item and closes the window again.
It is a simple batch-import approach that helps automate repetitive contact imports from multiple .vcf files.
Requirements
- Microsoft Outlook installed
- A folder named
C:\VCARDS - vCard files stored in that folder
Practical notes
This approach is useful when contacts are delivered as individual vCard files and need to be imported quickly. Because the macro works with Outlook windows directly, it should be tested carefully before using it in a productive environment.
Download the macro from GitHub here: GitHub repository