|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
January 13th 10, 07:32 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Prevent sending Excel files as attachements
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 
|
| Ads |
|
#2
January 13th 10, 08:16 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Prevent sending Excel files as attachements
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: 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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Prevent Outlook from sending an email with a blank Subject Line | Collector Dave | Outlook and VBA | 3 | November 8th 09 01:24 PM |
| prevent touching pst files | michiel.perdeck | Outlook - General Queries | 5 | August 5th 08 03:57 PM |
| Possible to prevent sending an email without a category? | [email protected] | Outlook - General Queries | 5 | July 27th 07 11:19 AM |
| Outlook XP - selecting default account when sending attachements via "sent to:" | Immanentny | Outlook - General Queries | 0 | February 20th 07 07:45 AM |
| how do you do you prevent outlook from sending copies | Crisra13 | Outlook - General Queries | 1 | November 17th 06 03:34 PM |
Linear Mode
