![]() |
|
#1
|
|||
|
|||
![]()
Thank you. I'm on my phone right now, but will try to give it a shot later today.
In my case, I'm not concerned with users expanding the distribution list. The more simple and consistent the matching then the more simple the process (usage rules) the users have to follow. Thanks again. I'll post back with the code I settle on. Andrew |
#2
|
|||
|
|||
![]()
This works perfectly for my needs. Thank you!
Code:
Option Explicit 'https://www.msofficeforums.com/outlook/30477-outlook-rule-not-send-if-attachment-name.html 'https://www.msofficeforums.com/member.php?u=26884 Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) Dim olAtt As Attachment Dim strCheck As String Dim bCheck As Boolean If Item.Attachments.Count > 0 Then For Each olAtt In Item.Attachments If olAtt.FileName Like "*File*.*" Then strCheck = Replace(olAtt.FileName, _ Right(olAtt.FileName, _ Len(olAtt.FileName) - _ InStrRev(olAtt.FileName, _ Chr(46)) + 1), "") strCheck = Replace(strCheck, "File ", "") 'Use the following line of code to assure Group/Distribution Name, Subject, and Attachment all contain the same keyword. 'If InStr(1, Item.Subject, strCheck) = 0 Or Not Item.To = strCheck Then 'Use the following line of code to only check that Subject and Attachment contain the same keyword. If InStr(1, Item.Subject, strCheck) = 0 Then MsgBox "Check the attachment(s)!" Cancel = True Exit For End If End If Next olAtt End If lbl_Exit: Exit Sub End Sub |
![]() |
Tags |
block attachment, block sending, outlook rule |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using a VLOOKUP - when 2 rows match criteria it returns the first value in the cel only how 2 change | djrobst | Excel | 4 | 10-28-2015 01:32 AM |
![]() |
caeiro01 | Excel | 1 | 10-25-2015 02:34 AM |
Outlook macro to check a value of a cell in an attachment and send an email based on that value | ketangarg86 | Outlook | 13 | 03-25-2015 07:11 AM |
![]() |
Astacus | Outlook | 1 | 12-29-2012 03:40 PM |
![]() |
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |