PC Review


Reply
Thread Tools Rate Thread

Count items when filtered

 
 
Brenda from Michigan
Guest
Posts: n/a
 
      21st Nov 2008
Outlook 2003 on an Exchange Server

I have an email folder I am filtering for items received yesterday and I
need a count of the results. When I turn on the filter, the Status Bar still
shows the total number of items in the folder, not the number that I just
filtered.

We are talking from 300-600 items per day. How can I get Outlook to give me
a total of those emails in a specific folder that were received yesterday?
Thanks!
 
Reply With Quote
 
 
 
 
VanguardLH
Guest
Posts: n/a
 
      21st Nov 2008
Brenda from Michigan wrote:

> Outlook 2003 on an Exchange Server
>
> I have an email folder I am filtering for items received yesterday and I
> need a count of the results. When I turn on the filter, the Status Bar still
> shows the total number of items in the folder, not the number that I just
> filtered.
>
> We are talking from 300-600 items per day. How can I get Outlook to give me
> a total of those emails in a specific folder that were received yesterday?
> Thanks!


Well, when "filtering", WHAT are you doing with the filtered out
e-mails? Are you moving them into a different folder? If so, you could
then go look at that other folder to see its item count in the status
bar. Enable auto-archiving and then set archiving on that other folder
to delete messages more than 1 day old (which only makes them eligible
for archiving so make sure the global archive function is configured to
run everyday).
 
Reply With Quote
 
Brenda from Michigan
Guest
Posts: n/a
 
      24th Nov 2008
I just need a count. How many email received (in this folder) yesterday, the
day before, the day before that. So far the only method I've found is to
sort the folder by date received, then move them one day at a time to a 2nd
folder. This is not a very high tech way to get a count but it might be the
best I can do.

We have just converted this email box from GroupWise to Outlook 2003.
GroupWise could easily filter by day (using a -1, -2, -3 etc. to determine
days before today, and gave us a count. Outlook only lets me filter by
yesterday, but even this still shows the total number of emails in the
folder, not the filtered number.

"VanguardLH" wrote:

> Brenda from Michigan wrote:
>
> > Outlook 2003 on an Exchange Server
> >
> > I have an email folder I am filtering for items received yesterday and I
> > need a count of the results. When I turn on the filter, the Status Bar still
> > shows the total number of items in the folder, not the number that I just
> > filtered.
> >
> > We are talking from 300-600 items per day. How can I get Outlook to give me
> > a total of those emails in a specific folder that were received yesterday?
> > Thanks!

>
> Well, when "filtering", WHAT are you doing with the filtered out
> e-mails? Are you moving them into a different folder? If so, you could
> then go look at that other folder to see its item count in the status
> bar. Enable auto-archiving and then set archiving on that other folder
> to delete messages more than 1 day old (which only makes them eligible
> for archiving so make sure the global archive function is configured to
> run everyday).
>

 
Reply With Quote
 
VanguardLH
Guest
Posts: n/a
 
      24th Nov 2008
Brenda from Michigan wrote:

>
> "VanguardLH" wrote:
>
>> Brenda from Michigan wrote:
>>
>>> Outlook 2003 on an Exchange Server
>>>
>>> I have an email folder I am filtering for items received yesterday and I
>>> need a count of the results. When I turn on the filter, the Status Bar still
>>> shows the total number of items in the folder, not the number that I just
>>> filtered.
>>>
>>> We are talking from 300-600 items per day. How can I get Outlook to give me
>>> a total of those emails in a specific folder that were received yesterday?
>>> Thanks!

>>
>> Well, when "filtering", WHAT are you doing with the filtered out
>> e-mails? Are you moving them into a different folder? If so, you could
>> then go look at that other folder to see its item count in the status
>> bar. Enable auto-archiving and then set archiving on that other folder
>> to delete messages more than 1 day old (which only makes them eligible
>> for archiving so make sure the global archive function is configured to
>> run everyday).
>>


> I just need a count. How many email received (in this folder) yesterday, the
> day before, the day before that. So far the only method I've found is to
> sort the folder by date received, then move them one day at a time to a 2nd
> folder. This is not a very high tech way to get a count but it might be the
> best I can do.
>
> We have just converted this email box from GroupWise to Outlook 2003.
> GroupWise could easily filter by day (using a -1, -2, -3 etc. to determine
> days before today, and gave us a count. Outlook only lets me filter by
> yesterday, but even this still shows the total number of emails in the
> folder, not the filtered number.


Different programs have different features. That is always to be
expected. I'm sure there are functions in Outlook that have no
counterpart in Groupwise.

You're stuck using Outlook because someone decided you had to move away
from Groupwise. So, you're stuck waiting for someone in your IT group
or your mail admin to come up with a VBA macro that can be installed as
an add-on to Outlook to provide functionality that is wanted in Outlook
but not there. They might find help at www.outlook-code.com. Someone
might come up with a custom view that you could select that uses SQL
directives which can specify age by days when selecting records from the
message store database, but the status bar's count would reflect how
many are viewed (it shows the total count).

Although you could save searches, I don't think even the Advanced Find
(under advanced tab) to find Received items would help. It doesn't let
you search based on age by days but only based on dates. The SQL tab
doesn't show up until you are defining a custom view and selecting the
filter criteria.

Advanced Folders Watch add-on from MapiLab might filter how you want to
give you the data you want. I can't tell from their product page if
they have a filter based on days age. It is a free add-on so you could
check it out. If it didn't do what you want, you didn't pay anything
for it so you just lost your time to investigate the product.
 
Reply With Quote
 
Brenda from Michigan
Guest
Posts: n/a
 
      25th Nov 2008
Thank you for all the good information. I will follow-up. For now I've made
a sub-folder and can drag all the items from the needed day to it and that
gives me the count I need. I'm also playing around with marking all items as
read and marking items for the needed day as unread which gives me the count
in the Folder List of unread messages. Either way beats manually counting.

Thanks again,
Brenda

"VanguardLH" wrote:

> Brenda from Michigan wrote:
>
> >
> > "VanguardLH" wrote:
> >
> >> Brenda from Michigan wrote:
> >>
> >>> Outlook 2003 on an Exchange Server
> >>>
> >>> I have an email folder I am filtering for items received yesterday and I
> >>> need a count of the results. When I turn on the filter, the Status Bar still
> >>> shows the total number of items in the folder, not the number that I just
> >>> filtered.
> >>>
> >>> We are talking from 300-600 items per day. How can I get Outlook to give me
> >>> a total of those emails in a specific folder that were received yesterday?
> >>> Thanks!
> >>
> >> Well, when "filtering", WHAT are you doing with the filtered out
> >> e-mails? Are you moving them into a different folder? If so, you could
> >> then go look at that other folder to see its item count in the status
> >> bar. Enable auto-archiving and then set archiving on that other folder
> >> to delete messages more than 1 day old (which only makes them eligible
> >> for archiving so make sure the global archive function is configured to
> >> run everyday).
> >>

>
> > I just need a count. How many email received (in this folder) yesterday, the
> > day before, the day before that. So far the only method I've found is to
> > sort the folder by date received, then move them one day at a time to a 2nd
> > folder. This is not a very high tech way to get a count but it might be the
> > best I can do.
> >
> > We have just converted this email box from GroupWise to Outlook 2003.
> > GroupWise could easily filter by day (using a -1, -2, -3 etc. to determine
> > days before today, and gave us a count. Outlook only lets me filter by
> > yesterday, but even this still shows the total number of emails in the
> > folder, not the filtered number.

>
> Different programs have different features. That is always to be
> expected. I'm sure there are functions in Outlook that have no
> counterpart in Groupwise.
>
> You're stuck using Outlook because someone decided you had to move away
> from Groupwise. So, you're stuck waiting for someone in your IT group
> or your mail admin to come up with a VBA macro that can be installed as
> an add-on to Outlook to provide functionality that is wanted in Outlook
> but not there. They might find help at www.outlook-code.com. Someone
> might come up with a custom view that you could select that uses SQL
> directives which can specify age by days when selecting records from the
> message store database, but the status bar's count would reflect how
> many are viewed (it shows the total count).
>
> Although you could save searches, I don't think even the Advanced Find
> (under advanced tab) to find Received items would help. It doesn't let
> you search based on age by days but only based on dates. The SQL tab
> doesn't show up until you are defining a custom view and selecting the
> filter criteria.
>
> Advanced Folders Watch add-on from MapiLab might filter how you want to
> give you the data you want. I can't tell from their product page if
> they have a filter based on days age. It is a free add-on so you could
> check it out. If it didn't do what you want, you didn't pay anything
> for it so you just lost your time to investigate the product.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I count items in a filtered list? =?Utf-8?B?Q291bnRpbmcgZmlsdGVyZWQgZGF0YS4=?= Microsoft Excel Worksheet Functions 40 22nd Mar 2010 05:23 PM
Automatic count for filtered items mbparks Microsoft Excel Misc 4 2nd Oct 2008 10:50 PM
Count Filtered Visible Items that Match Numeric Criteria between two ranges Sam via OfficeKB.com Microsoft Excel Worksheet Functions 4 20th Sep 2006 06:39 PM
how show 'count' of filtered items djc Microsoft Access Form Coding 1 3rd Oct 2003 03:34 PM
getting 'count' of filtered items? djc Microsoft Access Form Coding 1 3rd Oct 2003 12:29 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:17 AM.