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 / November 2005

Tip: Looking for answers? Try searching our database.

Counting filtered contacts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nathan1967 - 08 Nov 2005 13:35 GMT
Hi! I'd really appreciate some help with what, I suspect, is a simple question:

How do I count filtered contacts?

When the contacts are unfiltered - i.e. the whole of the contact list is
displayed - it says in the grey information bar (at the bottom) 292 items.
That's how many addresses are in my contact list at the moment (though it is
going to be much larger when I've finished).

When the contacts are filtered - e.g. according to category - the grey
information bar displays "filter applied" as well as 292 items. When only 4
items are displayed, this isn't much of a problem - as I can count to four
:-)  But as soon as my customer contact list is finished, I'm going to be
reaping filtered results of 200-300 addresses. Do I have to count them by
hand?

Any help would be appreciated and I'm prepared to kick myself if this was a
stupid question.

Many thanks,
Nathan
Diane Poremsky [MVP] - 08 Nov 2005 17:56 GMT
you could copy the rows and paste into notepad (or excel) and use it's line
count... it's not as quick as looking at the status bar, but beats doing 1,
2, 3...

http://www.outlook-tips.net/howto/copy_data.htm

Signature

Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

> Hi! I'd really appreciate some help with what, I suspect, is a simple
> question:
[quoted text clipped - 21 lines]
> Many thanks,
> Nathan
Nathan1967 - 09 Nov 2005 08:42 GMT
Thank you, Diane. Yes, it is a little tedious but it does work thanks to your
link (I had been copying them in such a way that I was only inserting a small
pdf-type-logo into Exel - but by selecting them all using Control-A rather
than marking them with the shift key worked a treat.

Perhaps the programmers will think of this for newer versions... it would
surely be no trouble at all to display, for example, 18/296 (where 18 are the
filtered results of 296 entries in the database).

Still, in the meantime, I'll be using your method: so thank you very much!

Regards,
Nathan

> you could copy the rows and paste into notepad (or excel) and use it's line
> count... it's not as quick as looking at the status bar, but beats doing 1,
[quoted text clipped - 27 lines]
> > Many thanks,
> > Nathan
 
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.