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

Need help with an automated email sender 0
Prevent Sending eMail from Excel 3
Email Help: Sending Outlook email from Excel VBA 6
Outlook Email Help: Select custom voting button options VBA 0
sending emails from access 3
Delete message after sending 2
Sending emails from Excels with attachements! 4
Attaching Files to Outlook 1

Top