Form Close Timer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 17 Mar 2008 01:46 GMT

I have an Outlook VBA app that I'm working on that takes an email generated
by our Emergency Dispatch System that contains information regarding
companies assigned to a structure fire. The email comes in and is handled by
a rule to move the email to a subfolder and play a notification sound event.
I then use the item_add method to open a userform that displays the content
of the message in a large font. When the form is closed, it deletes the
email. I would like to have the form stay open for 60 seconds then close and
delete the email. I can't seem to find a timer event to accomplish this. Any
ideas?

Reply to this Message

Ken Slovak - [MVP - Outlook] - 17 Mar 2008 13:47 GMT

VBA has no timers built-in among its control set, do you have VB6 installed?
That does come with a timer object. If you don't have VB6 you would have to
use something like a Win32 API timer object, which is much harder to work
with and set up.

An example of using such a timer is at
http://www.vbaccelerator.com/home/vb/code/Libraries/Threading/Multi-threading_us
ing_classes_in_ActiveX_EXEs/article.asp
for VB6 code. You should be able to modify the code to run in VBA code.

Signature

Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

>I have an Outlook VBA app that I'm working on that takes an email generated
> by our Emergency Dispatch System that contains information regarding
[quoted text clipped - 10 lines]
> Any
> ideas?

Reply to this Message