Prevent sending Excel files as attachements

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
 
M

Michael Bauer [MVP - Outlook]

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't send emails on new PC 1
Excel freezing after sharing document by Email 0
Mail Merge skipping records/sending one at a time 0
Embedded Excel into Word with Tables 0
Change a great number of words in word files, with a macro as short as possible. 5
Merging from an Excel file with graphics 1
Prevent Sending eMail from Excel 3
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top