Prevent sending Excel files as attachements

Status
Not open for further replies.
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
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
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

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
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
I How to prevent exchange email account from sending emails in Outlook Using Outlook 4
M Links prevent sending email Using Outlook 3
B how do you prevent email adressess from popping when sending a new email Using Outlook 1
K How to prevent that Outlook is sending before my add-in is finished? Outlook VBA and Custom Forms 5
C Prevent Outlook from sending an email with a blank Subject Line Outlook VBA and Custom Forms 3
D Prevent popup of "Do you want to save changes?" when closing after opening an appointment to view Outlook VBA and Custom Forms 2
O How to prevent CC from showing when creating a new mail? Using Outlook 1
A Prevent connection to Public Folders on Exchange? Exchange Server Administration 3
L OL 2016 contact: is there a way to prevent an admin from mistakenly deleting a contact? Using Outlook 1
D Multiple mailboxes, 1 certificate. How to prevent message "Invalid Certificate" Using Outlook 0
S How to prevent addins Using Outlook 0
makinmyway How Prevent Re-Formatting of Contact Notes Field When Syncing Using Outlook 10
Diane Poremsky Prevent Users From Choosing Stationery New Slipstick.com Articles 0
evdbogaard How to prevent extra line feeds in replies Using Outlook 3
oliv- Prevent copying shared contacts Outlook VBA and Custom Forms 5
oj43085 Prevent Outlook from blocking image from a single source Using Outlook 4
D Prevent Outlook from resolving incomplete contact when clicking send Using Outlook 2
K Prevent meeting requests being sent from a shared calendar in a group mailbox Using Outlook 1
N Prevent reminder dismisal in shared calendar Using Outlook 1
C Security Question - How to prevent users exporting .iaf files Using Outlook 5
B Item_Write = False don't prevent custom form from closing Using Outlook 1
T WAB editing: To help prevent malicious code from running.......... Using Outlook 18
N Allow Another User to Send on Behalf of But Prevent Access to Inbox Using Outlook 4
R Exchange 2010 archive-prevent users moving items direct to archive Exchange Server Administration 1
S How to Prevent of using CC field Using Outlook 1
D Received emails show only red X's no images - Email set for HTML. Prevent download of images is OFF Using Outlook 6
D Images showing up as X's in Outlook 2003 emails. Outlook is set to HTML and Prevent Picture downloa Using Outlook 2
V Prevent appointments not yet accepted from showing up in Calendars Using Outlook 3
B Prevent changing of appointment time or date by other users Using Outlook 1
J When I try to click on a link embedded in an email I get an error that says that computer restrictions prevent access. Call the system administrator Using Outlook 1
E Prevent Looping Message using transport rule Exchange Server Administration 4
C Prevent clients outlook anywhere URL from being changed by autodiscover? Using Outlook 4
L Prevent Exchange from becoming default account on Windows 7 Using Outlook 5
G To Prevent Malicious Code from running, one or more objects in thi BCM (Business Contact Manager) 2
S To help prevent malicious code from running, one or more objects in this form were not loaded. For m Outlook VBA and Custom Forms 1
A Script to either modify "from" address or prevent a reply being se Outlook VBA and Custom Forms 2
J prevent user from installing wrong version of add-in Outlook VBA and Custom Forms 2
Z Prevent Changes to Custom Form Outlook VBA and Custom Forms 1
A Flag Message for Follow Up after sending Outlook VBA and Custom Forms 1
D Sending email from Office 365 alias in Outlook Using Outlook 3
E Change sending account depending on Subjectline Outlook VBA and Custom Forms 0
L unblocking attachments before sending Office 365 Advanced Protection Using Outlook 0
B Outlook 2003 email sending & receiving suddenly stopped working Using Outlook 3
R Warn before sending message Outlook VBA and Custom Forms 4
HarvMan Hotmail - Sending email is undeliverable Using Outlook 4
A Sending contact vcards sends older version instead of updated version Using Outlook 4
M McAllister Outlook stops Sending/Receiving/Synching after disconnecting remote desktop session Using Outlook 2
D Adding Enterprise Exchange Email Account to Outlook Prevents Sending via Outlook.com Account Using Outlook.com accounts in Outlook 10
B When sending an email, I am showing 2 of my address's Using Outlook 1
M Auto expand Distribution List Before Sending Email Outlook VBA and Custom Forms 1

Similar threads

Top