Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / March 2008

Tip: Looking for answers? Try searching our database.

Number of members in a distribution list in Outlook?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
theia - 18 Mar 2008 11:49 GMT
How can you find out how many members are in a distribution list?  I often
have to create large dist lists (>50 members) and the only way I can be sure
that I have captured all of them is to manually count the members in the list.
Michael Bauer [MVP - Outlook] - 18 Mar 2008 12:08 GMT
This VBA sample displays the number of members:
http://www.vboffice.net/sample.html?mnu=2&pub=6&smp=37&cmd=showitem&lang=en

Signature

Best regards
Michael Bauer - MVP Outlook
 Use Outlook Categories? This is Your Tool:
 <http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Tue, 18 Mar 2008 03:49:04 -0700 schrieb theia:

> How can you find out how many members are in a distribution list?  I often
> have to create large dist lists (>50 members) and the only way I can be sure
> that I have captured all of them is to manually count the members in the list.
theia - 18 Mar 2008 23:52 GMT
Thank you very much!  This does the trick.  I still think MS could simply add
something that will allow someone to see information like this for a dist
list without having to program like this.  In any case, this will help me.  
Thanks again!
Brian Tillman - 19 Mar 2008 13:14 GMT
> Thank you very much!  This does the trick.  I still think MS could
> simply add something that will allow someone to see information like
> this for a dist list without having to program like this.  In any
> case, this will help me. Thanks again!

It would also be fairly easy to save the DL as a text file and them open it
in Excel to see how many rows you have.  No extra programming needed
(although, I admit the code is a bit more convenient).
Signature

Brian Tillman [MVP-Outlook]


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.