Microsoft since 2005:
|Author: Michael Bauer||Homepage|
|Date: 03.12.2006||Accessed: 25543|
| || |
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.
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)
Set obj = Application.ActiveInspector.CurrentItem
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"
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]