StartDownloadsServiceSamplesWorkshopsContact DeutschEnglish
Awarded by
Microsoft since 2005:
mvp logo
VBOffice Info
Privacy Policy
Distribution List: Display the count of the member
Author: Michael BauerHomepage
Date: 03.12.2006Accessed: 25922

A distribution list's member count is limited. But Outlook doesn't tell you how many members are already in a list.

You get the information with a few lines of code. Please copy the sample into the module 'ThisOutlookSession' and save it. Right click on a toolbar, Customize/Commands/Macros, and drag the name of the macro to a toolbar. By clicking that new button you can call the function if a distribution list is selected.

Option Explicit

Public Sub ShowMemberCount()
  Dim obj As Object
  Dim DL As Outlook.DistListItem

  If TypeOf Application.ActiveWindow Is Outlook.Explorer Then
    If Application.ActiveExplorer.Selection.Count Then
      Set obj = Application.ActiveExplorer.Selection(1)
    End If
    Set obj = Application.ActiveInspector.CurrentItem
  End If

  If Not obj Is Nothing Then
    If TypeOf obj Is Outlook.DistListItem Then
      Set DL = obj
      MsgBox "Name: " & DL.DLName & _
        vbCrLf & "Member: " & DL.MemberCount, _
        , "Member Count"
    End If
  End If
End Sub

ReplyAll alerts you before unintentionally replying all, or if you are a confidential BCC recipient of the ... [more]


Access the master category list in the blink of an eye, share your categories in a network, get a reminder service, and ... [more]


SAM automatically sets the sender, signature, and folder for sent items, for instance based on the recipient ... [more]


OLKeeper reliably prevents users from closing their Outlook window and thus possibly missing reminders or ... [more]