View Single Post
  #4  
Old November 2nd 06, 08:04 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,333
Default create a Outlook macro which will check for non arrival of mai

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:

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.

"Michael Bauer [MVP - Outlook]" wrote:

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.

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

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?


Ads
 

Fast Loans - Debt Consolidation - Bad Credit Mortgages - Loans - MPAA