Outlook Interceptor

Screen captures

	Slide Show (opens in another window)
	Startup and timer activation screen, plus screens for configuring file naming, email notices, and listing the completed jobs

TECH NOTE: Overcoming many variable conditions

Several problems were addressed during this application's development and operation, which made developing Outlook Interceptor a particularly challenging and rewarding endeavor:

• Received email file attachments, Adobe Acrobat .PDF documents, had to be renamed with a filename that reflected a particular newsletter and its publication date.
• File naming had to account for weekends and holidays.
• Outlook by itself could not perform all the necessary functions automatically, so Access was placed on a timer function (by calling timeGetTime, from winmm.dll) to repeatedly open Outlook and perform Inbox scanning operations.
• Old email messages that met scanning criteria had to be cleared from the Inbox and preserved in special mail folders.
• Attributes that were characteristic of a desired, target email might not exist for certain Outlook 'Item' objects (example: a system message indicating non-deliverable email), so a check for these attributes on the 'wrong' type of Item object could cause the program to fail.
• Email notifications, sent after successful program operation, needed to be sent to different groups of recipients that correlated with different managers for different newsletters.