Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Distribution Lists - Numbers (2002)

    Is there a relatively easy way of finding out how many people I have in a distribution list?

  2. #2
    Star Lounger
    Join Date
    Mar 2004
    Location
    Calgary, Alberta, Canada
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Distribution Lists - Numbers (2002)

    Unfortunately, Outlook has no feature that 'counts' the items in a distribution list. You will need to use VBA code to perform this task. Here's some code which I found that may help you out:

    Sub PDLMemberCount()
    Dim objDistList As Outlook.DistListItem
    Dim iMemberCount As Long

    Set objDistList = Application.ActiveExplorer.Selection.Item(1)
    iMemberCount = objDistList.MemberCount

    MsgBox "Member count: " & CStr(iMemberCount), vbOKOnly, "Microsoft Outlook"

    End Sub


    Ensure to Select Tools, Macro, Security and change the security level to Medium/Low (Medium will prompt to allow an unsigned macro.)

    If you do not know where to place this macro or use it afterwards, please post back and someone can help out! Hope this helps... trish

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Distribution Lists - Numbers (2002)

    Or, open (activate) the DistList, then in the VBE, open the Immediates window (Ctrl-G) and enter:

    ?ActiveInspector.CurrentItem.MemberCount
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    New Lounger
    Join Date
    Mar 2004
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Distribution Lists - Numbers (2002)

    Thanks very much indeed for this. It is quite elegant and will save me stacks of time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •