Email Registration / Scanning

[NR]

At my work we are using Outlook 2000 & 2003. I got an assignment to keep
record of some important emails in MS-Access database. E-mail originator can
be any one from the company, as he clicks send button message body should be
saved in MS-Access database.
I can work on VBA but don't find any solution, how to do this job in
Outlook. I am not allowed to use any new interface outside Outlook e.g.
MS-Access or VB. I have to perform this job being in Outlook so that once
customized pach is installed then no one can by pass procedures and every
email will be scanned before going out.
Is there any one who can help me in this regard. I will be very thankful.

Regards,
NR

 

[Sue Mosher [MVP-Outlook]]

What you want to do is not possible within the parameters you define, for the following reasons:

1) There is no installation "story" for VBA code. It is for the user's personal use. Even if you protect a VBA project and replace the user's existing VBA project, the user can easily delete the VBAProject.OTM file to prevent your code from running.

2) While a COM add-in built with VB would provide a good installation story, I can think of several ways that a savvy user could bypass any code intended to monitor all outgoing items.

Frankly, this scenario calls for an application that is integrated into your mail server, not a client application.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers