| | Awarded by
Microsoft since 2005: |  |
| | VBOffice Info | | Visitors | 1388253 | | Impressions | 5084500 |
| |
|
| |
| Author: Michael Bauer | Homepage | | Date: 03.12.2006 | Accessed: 19388 | | | | Description
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
Else
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] |
| |
|
