Keeping Count of Emails

M

Murphybp2

I am trying to implement Sue Mosher's solution for counting the number
of emails received per day described in her article on WindowsItPro
(http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=9167). I was
able to get it working on my home computer with Outlook 2002. However
when I duplicated the same VBA in the same way on my work computer,
which is Outlook 2003, it doesn't work. I can manually run the macro
and it will add a single item to the message count, but it doesn't
automatically work when a message comes in. I checked my macro setting
and it is at medium. So I get a pop-up when I log in asking me if I
want to enable macros and I click Yes. But the macro still doesn't
seem to be working.

Is there anything special I need to do because this is outlook 2003, or
because this is on an exchange network to get this to work
automatically?
 
S

Sue Mosher [MVP-Outlook]

If you have any On Error Resume Next statements in your code, comment them out and report back on any error messages you get.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
M

Murphybp2

Sue,

There aren't any On Error Resume Next statements in the code. I had
read a comment on that article where you told someone that they may
need to add an Exchange Event server script.....but I don't know what
that is or how I would do that. I have very limited understanding of
outlook VBA. I basically know how to copy and paste code. And that's
what I did for this. I copied your exact code from that article
without any changes.
 
S

Sue Mosher [MVP-Outlook]

An Exchange event server script is an entirely different kind of application, written with a different programming library, not Outlook. The VBA code from that article should work OK in Outlook 2003 running against Exchange, unless you get a lot of items in the Inbox at once, in which case the ItemAdd event won't fire. I don't know why you're seeing the behavior you have.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Top