Prevent sending Excel files as attachements

  • Thread starter Thread starter kurthh
  • Start date Start date
K

kurthh

Hello

I use Outlook 2003 as my email program.
Unfortunately, I have sent some Excel files as an attachment, which
would not have been sent out.
Is it possible to use a macro to prevent Outlook from sending if the
email contains an Excel File

thanks

Kurt
 
in the ItemSend event check the Attachments collection for the item. For
each attachment in that collection check the Filename property. If there's
one that ends with ".xls" or the like, set Cancel = True.

--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 12 Jan 2010 23:32:51 -0800 (PST) schrieb kurthh:
 
Back
Top