--- description: In general, to check a contact group’s members, you have to first open it. If you wish to see the contact group members directly in the list without opening it, you could utilize the approach shared in this article. title: How to Display the Members of Contact Group in List via Outlook VBA image: https://www.datanumen.com/blogs/wp-content/uploads/2017/08/display-the-members-of-contact-group-in-list-via-outlook-vba.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 Display the Members of Contact Group in List via Outlook VBA # How to Display the Members of Contact Group in List via Outlook VBA [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) September 29, 2025 Share Now: - - - - - - - - *In general, to check a contact group’s members, you have to first open it. If you wish to see the contact group members directly in the list without opening it, you could utilize the approach shared in this article.* From my previous article – “ [How to Auto Display the Member Counts in Outlook Contact Groups](https://www.datanumen.com/blogs/auto-display-member-counts-outlook-contact-groups/)”, you can learn how to display the count of group members in list. Similar to that, many users hope to directly show the concrete group members in a separate column. Therefore, here we will teach you how to achieve it. ![Display the Members of Contact Group in List via Outlook VBA](https://www.datanumen.com/blogs/wp-content/uploads/2017/08/display-the-members-of-contact-group-in-list-via-outlook-vba.jpg "Display the Members of Contact Group in List via Outlook VBA") ## Display Members of Contact Group in List 1. To begin with, launch your Outlook application. 2. Then, you can press “Alt + F11” keys to access VBA editor. 3. In the subsequent “Microsoft Visual Basic for Applications” window, open the “ThisOutlookSession” project. 4. Next, copy and paste the following VBA code into this project. ``` Private WithEvents olItems As Outlook.Items Private objContactGroup As Outlook.DistListItem Private objProperty As Outlook.UserProperty Private strProperName As String Private i As Long Private objGroupMember As Outlook.recipient Private strMemberName, strMembers As String Private Sub Application_Startup() Set olItems = Application.Session.GetDefaultFolder(olFolderContacts).Items 'Auto Update the members in group list on startup Call DisplayMembers End Sub 'Auto Display the members of new Contact Group Private Sub olItems_ItemAdd(ByVal Item As Object) If TypeOf objItem Is DistListItem Then strProperName = "Members" Set objProperty = objCurrentItem.UserProperties.Find(strProperName, True) Set objContactGroup = objItem Set objProperty = objContactGroup.UserProperties.Add(strProperName, olText, True) For i = 1 To objContactGroup.MemberCount Set objGroupMember = objContactGroup.GetMember(i) strMemberName = Split(objGroupMember.Address, "@")(0) strMemberName = UCase(Left(strMemberName, 1)) & Right(strMemberName, Len(strMemberName) - 1) strMembers = strMembers & strMemberName & "; " Next i objProperty.value = strMembers objContactGroup.Save End If End Sub Sub DisplayMembers() For Each objItem In olItems If TypeOf objItem Is DistListItem Then strProperName = "Members" Set objProperty = objItem.UserProperties.Find(strProperName, True) Set objContactGroup = objItem Set objProperty = objContactGroup.UserProperties.Add(strProperName, olText, True) 'Get the names of all group members For i = 1 To objContactGroup.MemberCount Set objGroupMember = objContactGroup.GetMember(i) strMemberName = Split(objGroupMember.Address, "@")(0) strMemberName = UCase(Left(strMemberName, 1)) & Right(strMemberName, Len(strMemberName) - 1) strMembers = strMembers & strMemberName & "; " Next i objProperty.value = strMembers objContactGroup.Save End If strMembers = "" Next End Sub ``` ![VBA Code - Display the Members of Contact Group in List]( "VBA Code - Display the Members of Contact Group in List") 5. Next, you should click into the “Application\_Startup” subroutine and click the “Run” icon in the toolbar, which will trigger this macro at once. 6. After that, exit the VBA editor and continue to add “Members” field to contact group list. - In the Contacts pane, access the correct folder. - Then switch to “View” tab and click “Change View” and select “List”. - Next hit “View Settings” button. - Later, click “Columns” in the newly popup dialog box. - In subsequent “Show Columns” dialog box, add the “Members” field by following the steps shown in the screenshot below:![Add the “Members” field]( "Add the “Members” field") 7. Finally, you could back to the contacts folder. You will see the members in the contact group list, like the following image:![Group Members in List]( "Group Members in List") 8. From now on, every time when you start Outlook, it’ll auto update the list of members of each contact group. 9. Also, Outlook will auto get and display the members of new contact group in the “Members” column. ## Keep Well-Prepared for Outlook Corruption Even though Outlook is feature rich, it still cannot keep far away from damage. So you have to keep vigilant against all the potential risks. Without any doubts, you need to make a consistent and up-to-date backup for your PST data. What’s more, you’re better off keeping a remarkable and dependable [PST fix](https://www.datanumen.com/outlook-repair/) tool handy, such as 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 [mdf fix](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/will-happen-hard-drive-firmware-corrupted/) [Next post →](https://www.datanumen.com/blogs/2-methods-copy-members-one-contact-group-another-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\/display-members-contact-group-list-via-outlook-vba\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/display-members-contact-group-list-via-outlook-vba\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Display the Members of Contact Group in List via Outlook VBA","datePublished":"2017-08-03T03:12:33+00:00","dateModified":"2025-09-29T10:39:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/display-members-contact-group-list-via-outlook-vba\/"},"wordCount":413,"commentCount":0,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/display-members-contact-group-list-via-outlook-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/08\/display-the-members-of-contact-group-in-list-via-outlook-vba.jpg","articleSection":["Outlook Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/display-members-contact-group-list-via-outlook-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/display-members-contact-group-list-via-outlook-vba\/","url":"https:\/\/www.datanumen.com\/blogs\/display-members-contact-group-list-via-outlook-vba\/","name":"How to Display the Members of Contact Group in List via Outlook VBA","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/display-members-contact-group-list-via-outlook-vba\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/display-members-contact-group-list-via-outlook-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/08\/display-the-members-of-contact-group-in-list-via-outlook-vba.jpg","datePublished":"2017-08-03T03:12:33+00:00","dateModified":"2025-09-29T10:39:43+00:00","description":"In general, to check a contact group’s members, you have to first open it. If you wish to see the contact group members directly in the list without opening it, you could utilize the approach shared in this article.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/display-members-contact-group-list-via-outlook-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/display-members-contact-group-list-via-outlook-vba\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/08\/display-the-members-of-contact-group-in-list-via-outlook-vba.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/08\/display-the-members-of-contact-group-in-list-via-outlook-vba.jpg","width":1359,"height":941,"caption":"Display the Members of Contact Group in List via 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\/"]}]} ```