create a Outlook macro which will check for non arrival of mail

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a reporting tool which sends a mail after the report ran successfully.

I want to write an Outllok macro which will check to see if all the mails
were received by 5 am and if any one did not arrive, will send an alert mail
to a user with the name of the report that did not finish.

Is this possible in outlook?
 
Am Tue, 31 Oct 2006 13:53:02 -0800 schrieb srisubha:

If you send the reports you could check the Sent Items folder: Use the
Restrict function and restrict for a determined subject and the date of the
day. Then compare the result with a list of all users who are supposed to
get the e-mail.
 
Hi Michael,
I think I need to explain my problem more clearly.
Everyday, I know that some mails will come to me after the reports ran
successfully.
One mail for each report.

What I want to do is to keep track and alert the users if any of those mails
do not arrive in my Inbox ( because that would mean the report did not run
successfully).

Hope this helps.
 
That´s even easier. I`d create a new class module with two member:

<class>
Public Address as string
Public Arrived as Boolean
</class>

Once, e.g. in Application_Startup, add one object of that class to a
collection, one for each address. If you use the address also as collection
key, it´s easy to access the items.

Track with ItemsAdd for the Inbox the returning mails. Find that address in
the collection and set the Arrived flag = True.

Create a recurring TaskItem that´s due at 5am with a specific subject. if
the Reminder event fires, check for the subject and start a procedure that
loops through the collection. If it finds one item with Arrived=False then
use the Address property to send an e-mail. For all other items set the
Arrived property = False.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --



Am Wed, 1 Nov 2006 09:44:01 -0800 schrieb srisubha:
 
Back
Top