Checking Outlook E-mail before sending through Excel

Hi, I am using some code in Outlook to check e-mails before they are sent (using the Application_ItemSend event).

This works fine when I create a new e-mail but if I use Excel with the File>Send To>Mail Recipient (As Attachment) option, it completely ignores my checks and just sends it.

Has anyone had experience with this and could help with a solution pls?

Thanks
John

Hi, after much searching I have now got it working (via a workaround). Also, this was just not an Excel problem - it happened from Word or any other program with a File>Send To>Mail Recipient option.

1. I still have all my checking code in Application_ItemSend event and also have another procedure that simply has the following code

Please Login or Register  to view this content.

2. I have then modified the users new email form to remove the normal Send buttons (on File Menu as well) and replaced with a button for my ActiveInspector macro

This then correctly performs all the checks regardless of which program called the email form up.