--- description: By default, you can only see the member names and email addresses in a contact group. If you wish to get the members’ other details, you can use the way introduced in this article. title: How to Quickly Export the Details of All Members in an Outlook Contact Group to Excel image: https://www.datanumen.com/blogs/wp-content/uploads/2017/06/quickly-export-the-details-of-all-members-in-an-outlook-contact-group-to-excel.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 the Details of All Members in an Outlook Contact Group to Excel # How to Quickly Export the Details of All Members in an Outlook Contact Group to Excel [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) September 29, 2025 Share Now: - - - - - - - - *By default, you can only see the member names and email addresses in a contact group. If you wish to get the members’ other details, you can use the way introduced in this article.* When you double click a contact group to open it, in its window, you can only see the group members’ names and email addresses. You are unable to get members’ other details, like company, job title, phone number or business address, etc. In general, to get these details, you have to find the contacts corresponding to the members in your Contacts folder manually. It’s too troublesome. Here we will show you a piece of VBA code, which can quickly export these details to an Excel workbook. ![Quickly Export the Details of All Members in an Outlook Contact Group to Excel](https://www.datanumen.com/blogs/wp-content/uploads/2017/06/quickly-export-the-details-of-all-members-in-an-outlook-contact-group-to-excel.jpg "Quickly Export the Details of All Members in an Outlook Contact Group to Excel") ## Export the Details of All Members in a Contact Group to Excel 1. To start with, launch your Outlook application. 2. Then you should press “Alt + F11” key shortcuts in the main Outlook window. 3. Next in the new “Microsoft Visual Basic for Applications” window, you need to open a not-in-use module or directly insert a new module. 4. Subsequently, copy and paste the following VBA code into this module. ``` Sub ExportMemberContactDetailsToExcel() Dim objContactGroup As Outlook.DistListItem Dim objGroupMember As Outlook.recipient Dim objContacts As Outlook.Items Dim objFoundContact As Outlook.ContactItem Dim objExcelApp As Excel.Application Dim objExcelWorkBook As Excel.Workbook Dim objExcelWorkSheet As Excel.Worksheet Dim i As Integer Dim nRow As Integer Dim strFilename As String Set objContactGroup = Application.ActiveExplorer.Selection(1) 'Create a new Excel workbook Set objExcelApp = CreateObject("Excel.Application") Set objExcelWorkBook = objExcelApp.Workbooks.Add Set objExcelWorkSheet = objExcelWorkBook.Worksheets(1) 'Set the seven column headers With objExcelWorkSheet .Cells(1, 1) = "Name" .Cells(1, 2) = "Email Address" .Cells(1, 3) = "Company" .Cells(1, 4) = "Job Title" .Cells(1, 5) = "Phone Number" .Cells(1, 6) = "Mailing Address" .Cells(1, 7) = "Birthday" End With Set objContacts = Application.Session.GetDefaultFolder(olFolderContacts).Items.Restrict("[Email1Address]>''") nRow = 2 For i = 1 To objContactGroup.MemberCount Set objGroupMember = objContactGroup.GetMember(i) strFilter = "[Email1Address] = '" & objGroupMember.Address & "'" Set objFoundContact = objContacts.Find(strFilter) If Not (objFoundContact Is Nothing) Then 'Input the Contact Details With objExcelWorkSheet .Cells(nRow, 1) = objFoundContact.FullName .Cells(nRow, 2) = objFoundContact.Email1Address .Cells(nRow, 3) = objFoundContact.CompanyName .Cells(nRow, 4) = objFoundContact.JobTitle .Cells(nRow, 5) = objFoundContact.BusinessTelephoneNumber .Cells(nRow, 6) = objFoundContact.MailingAddress If objFoundContact.Birthday = #1/1/4501# Then .Cells(nRow, 7) = "" Else .Cells(nRow, 7) = objFoundContact.Birthday End If End With Else With objExcelWorkSheet .Cells(nRow, 1) = objGroupMember.Name .Cells(nRow, 2) = objGroupMember.Address End With End If nRow = nRow + 1 Next 'Fit the columns objExcelWorkSheet.Columns("A:G").AutoFit 'Change the Path as per where you want to save the new Excel file strFilename = "E:\" & objContactGroup.DLName & " Member Contact Details.xlsx" 'Save the Excel workbook objExcelWorkBook.Close True, strFilename MsgBox ("Complete!") End Sub ``` ![VBA Code - Export the Details of All Members in an Outlook Contact Group to Excel Workbook]( "VBA Code - Export the Details of All Members in an Outlook Contact Group to Excel Workbook") 5. After that, for convenient check, you can add the new VBA project to Quick Access Toolbar or ribbon. 6. Later set your Outlook macro security level to low. 7. Ultimately, you can have a try. - First, select a contact group. - Then press the macro button in Quick Access Toolbar or ribbon.![Run the New Macro]( "Run the New Macro") - Immediately, the macro will run. - When it finishes, you will get a prompt of “Complete!” - After that, you can go to the predefined destination local folder, in which you can find a new Excel file. - Open it, you’ll see the group members’’ contact details like the following screenshot:![Exported Member Details]( "Exported Member Details") ## Don’t Panic in Face of Outlook Issues No one is willing to accept any Outlook troubles, no matter popup error message or [corrupt Outlook](https://www.datanumen.com/outlook-repair/) data file. Therefore, users will tend to get panic when coming across Outlook issues. If you want to keep calm in that case, you should have two necessities in hand. One is current Outlook data backups. The other one is potent Outlook fix software, like DataNumen Outlook Repair. ## Author Introduction: Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [sql recovery](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-attach-multiple-appointments-icalendar-ics-files-outlook-email/) [Next post →](https://www.datanumen.com/blogs/5-common-causes-prevention-tips-disk-partition-table-corruption/) 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-details-members-outlook-contact-group-excel\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-details-members-outlook-contact-group-excel\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Quickly Export the Details of All Members in an Outlook Contact Group to Excel","datePublished":"2017-06-19T01:23:17+00:00","dateModified":"2025-09-29T10:41:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-details-members-outlook-contact-group-excel\/"},"wordCount":410,"commentCount":1,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-details-members-outlook-contact-group-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/06\/quickly-export-the-details-of-all-members-in-an-outlook-contact-group-to-excel.jpg","articleSection":["Outlook Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/quickly-export-details-members-outlook-contact-group-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-details-members-outlook-contact-group-excel\/","url":"https:\/\/www.datanumen.com\/blogs\/quickly-export-details-members-outlook-contact-group-excel\/","name":"How to Quickly Export the Details of All Members in an Outlook Contact Group to Excel","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-details-members-outlook-contact-group-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-details-members-outlook-contact-group-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/06\/quickly-export-the-details-of-all-members-in-an-outlook-contact-group-to-excel.jpg","datePublished":"2017-06-19T01:23:17+00:00","dateModified":"2025-09-29T10:41:11+00:00","description":"By default, you can only see the member names and email addresses in a contact group. If you wish to get the members’ other details, you can use the way introduced in this article.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/quickly-export-details-members-outlook-contact-group-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/quickly-export-details-members-outlook-contact-group-excel\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/06\/quickly-export-the-details-of-all-members-in-an-outlook-contact-group-to-excel.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/06\/quickly-export-the-details-of-all-members-in-an-outlook-contact-group-to-excel.jpg","width":1276,"height":552,"caption":"Quickly Export the Details of All Members in an Outlook Contact Group to Excel"},{"@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\/"]}]} ```