Keeping Count of Emails

  • Thread starter Thread starter Murphybp2
  • Start date Start date
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?
 
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
 
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.
 
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
 
Back
Top