From Code for Excel and Outlook
Sorry for the lack of posts lately. I've been working on the next version of Random Data Generator, and my home network connection wasn't working for the past few days.
In Display the Total Number of Members in a Contact Group there is a method for displaying the number of members of a contact group (aka distribution list).
There is an easier way, using VBA:
Sub GetDistListCount()
Dim dl As Outlook.DistListItem
Set dl = ActiveExplorer.Selection.item(1)
MsgBox "There are " & dl.MemberCount & " member(s) in this contact group."
End Sub
Dim dl As Outlook.DistListItem
Set dl = ActiveExplorer.Selection.item(1)
MsgBox "There are " & dl.MemberCount & " member(s) in this contact group."
End Sub
Just go to your Contacts folder, select a distribution list item and run this code. There is no error handling here, just a simple procedure to display the number of members of the group.
Related Articles:
- June 23, 2011 -- Manage your email overload
- March 7, 2011 -- Get Word Count in VBA
- January 31, 2011 -- Add photos to Contacts in bulk using VBA in Outlook
Display Contact Group Member Count is Copyright © JP Software Technologies. All Rights Reserved.
没有评论:
发表评论