I have no experience in building COMs add-ins.
I'm not a programmer and had this landed on me.
On Tue, 21 Feb 2006 13:39:30 -0500, "Sue Mosher [MVP-Outlook]"
wrote:
I don't see any code yet to instantiate colInsp. If you want the whole routine to run automatically, you need code in the Application_Startup event handler in ThisOutlookSession to handle that.
As I said in my earlier post, if you check the value of the message's Sent property and it equals False, then you know you have a reply, forward, or new message, one that you don't want to process.
Other issues:
Outlook VBA includes an intrinsic Application object, so you don't need to use CreateObject to create another one.
Also, you said "users." Outlook VBA code is not meant to be redistributed. Ultimately, you should be thinking about building this functionality into an OUtlook COM add-in. See http://www.outlookcode.com/d/comaddins.htm