Outlook rule to not send if attachment name doesn't match criteria

gmayor · #9 03-19-2016, 10:33 PM

The macro looks for an outgoing message with Personal Information in the attachment filename. It then strips the Personal Information text from the filename and looks to see if the remaining name is in the subject and then flags a warning no matter who the message is sent to.

The problem with using a distribution list is that it can only be identified as a list by looking at .To, if the list has not been expanded.

To see what I mean, send a message to the outbox (without sending immediately) with the three parameters correct then open and resend the message from the outbox. The message will still go through with the original code, but with the change below it will now not, because the sender is now the members of the group and not the group.

Based on your updated requirement, what I believe you now require would be to change

Code:

If InStr(1, Item.Subject, strCheck) = 0 Then

to

Code:

If InStr(1, Item.Subject, strCheck) = 0 Or Not Item.To = "Bob" Then

Similar Threads
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
Count unique values that match 2 or more criteria	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
Outlook doesn't send/receive anymore.	Astacus	Outlook	1	12-29-2012 03:40 PM
Vlookup or Index/Match - Multiple Criteria	ruci1225	Excel	1	01-15-2012 07:31 AM