--- description: If you have multiple contacts in your Outlook and want to export them to a single vCard file, instead of separate files, you can use the smart method introduced in this article. title: How to Quickly Export Multiple Contacts to One VCard File with Outlook VBA image: https://www.datanumen.com/blogs/wp-content/uploads/2017/12/quickly-export-multiple-contacts-to-one-vcard-file.jpg --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) > How to Quickly Export Multiple Contacts to One VCard File with Outlook VBA # How to Quickly Export Multiple Contacts to One VCard File with Outlook VBA [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) September 29, 2025 Share Now: - - - - - - - - *If you have multiple contacts in your Outlook and want to export them to a single vCard file, instead of separate files, you can use the smart method introduced in this article.* For instance, you need to send hundreds of contacts to some else. Rather than sending them as separate vCard files, you may be eager to combine them into a single vCard file and then send it. Actually, my previous article – “ [How to Export Multiple Outlook Contacts as a Single VCard File](https://www.datanumen.com/blogs/export-multiple-outlook-contacts-single-vcard-file/)” has introduced a method. However, that approach demands you to have a Gmail account and use “Import and Export” feature of Gmail. In a nutshell, that is pretty cumbersome. Therefore, here we will introduce a handier method to you.![Quickly Export Multiple Contacts to One VCard File with Outlook VBA]( "Quickly Export Multiple Contacts to One VCard File with Outlook VBA") ## Quickly Export Multiple Contacts to One vCard File 1. First off, launch your Outlook application. 2. Then, tap on “Alt + F11” keys to access VBA editor. 3. Next, in the new window, put the VBA code into a module. ``` Sub ExportMultipleContactsIntoOneVCardFile() Dim objSelection As Outlook.Selection Dim strLocalDrive, strFolder As String Dim i As Long Dim objContact As Outlook.ContactItem Dim strVCardFile As String 'Get all selected contacts Set objSelection = Outlook.Application.ActiveExplorer.Selection If Not objSelection Is Nothing Then 'Save contacts in "E:\Temp Contacts\" strLocalDrive = "E:" strFolder = "Temp Contacts" MkDir (strLocalDrive & "\" & strFolder & "\") 'Save all selected contacts as separate vCards For i = objSelection.Count To 1 Step -1 If TypeName(objSelection(i)) = "ContactItem" Then Set objContact = objSelection(i) strVCardFile = strLocalDrive & "\" & strFolder & "\" & objContact.FullName & ".vcf" objContact.SaveAs strVCardFile, olVCard End If Next 'Use cmd to merge all exported vCard files into one Shell "cmd.exe /K" & strLocalDrive & " & CD " & strFolder & " & copy *.vcf MergedContact.vcf" End If End Sub ``` ![VBA Code - Quickly Export Multiple Contacts into One VCard File]( "VBA Code - Quickly Export Multiple Contacts into One VCard File") 4. After that, add this macro to Quick Access Toolbar with reference to “ [How to Run VBA Code in Your Outlook](https://www.datanumen.com/blogs/run-vba-code-outlook/)“. 5. Eventually, you can try this macro right now. - For a start, select the contacts which you want to export. - Then, click the macro button in Quick Access Toolbar.![Run Macro on Selected Contacts]( "Run Macro on Selected Contacts") - Later you will see a command prompt window, which indicates that all the contacts are merged into one.![Command Prompt]( "Command Prompt") - Now, you can go to “E:\\Temp Contacts” folder in your Windows Explorer. - In this local folder, you will find a vCard file named as “MergedContact”, which is the file containing all the selected contacts.![Merged vCard File]( "Merged vCard File") ## Repair Your Outlook Data after Crashes As Outlook is susceptible to corruption, you need to take good care of your PST file. For instance, you need to keep closing your Outlook in proper manner. Also, it is suggested to never click unknown links or download attachments embedded in emails. Moreover, you had better get hold of a powerful [PST repair](https://www.datanumen.com/outlook-repair/) utility, such as DataNumen Outlook Repair. With it, even if your Outlook file gets corrupt, you still can repair it with effortless ease. ## Author Introduction: Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [corrupt SQL Server](https://www.datanumen.com/sql-recovery/) and outlook repair software products. For more information visit [www.datanumen.com](https://www.datanumen.com/) Share Now: - - - - - - - - [← Previous post](https://www.datanumen.com/blogs/batch-clear-color-categories-outlook-items/) [Next post →](https://www.datanumen.com/blogs/auto-move-sent-meeting-invitations-specific-folder-outlook/) Comments are closed. ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-multiple-contacts-one-vcard-file-outlook-vba\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-multiple-contacts-one-vcard-file-outlook-vba\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Quickly Export Multiple Contacts to One VCard File with Outlook VBA","datePublished":"2017-12-23T03:20:34+00:00","dateModified":"2025-09-29T09:10:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-multiple-contacts-one-vcard-file-outlook-vba\/"},"wordCount":392,"commentCount":0,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-multiple-contacts-one-vcard-file-outlook-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/12\/quickly-export-multiple-contacts-to-one-vcard-file.jpg","articleSection":["Outlook Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/quickly-export-multiple-contacts-one-vcard-file-outlook-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-multiple-contacts-one-vcard-file-outlook-vba\/","url":"https:\/\/www.datanumen.com\/blogs\/quickly-export-multiple-contacts-one-vcard-file-outlook-vba\/","name":"How to Quickly Export Multiple Contacts to One VCard File with Outlook VBA","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-multiple-contacts-one-vcard-file-outlook-vba\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-multiple-contacts-one-vcard-file-outlook-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/12\/quickly-export-multiple-contacts-to-one-vcard-file.jpg","datePublished":"2017-12-23T03:20:34+00:00","dateModified":"2025-09-29T09:10:40+00:00","description":"If you have multiple contacts in your Outlook and want to export them to a single vCard file, instead of separate files, you can use the smart method introduced in this article.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/quickly-export-multiple-contacts-one-vcard-file-outlook-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-multiple-contacts-one-vcard-file-outlook-vba\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/12\/quickly-export-multiple-contacts-to-one-vcard-file.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/12\/quickly-export-multiple-contacts-to-one-vcard-file.jpg","width":2560,"height":1138,"caption":"Quickly Export Multiple Contacts to One VCard File with Outlook VBA"},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]},{"@type":"Person","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957","name":"AuthorCCW","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","caption":"AuthorCCW"},"sameAs":["https:\/\/www.datanumen.com\/"]}]} ```