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

gmayor · #1 03-18-2016, 10:15 PM

OK if it is always a distribution list called BOB then surround the

Code:

If Item.Attachments.Count > 0 Then
    '...............
End If

with

Code:

If Item.To = "Bob" then
    If Item.Attachments.Count > 0 Then
        '...............
    End If
End if

However I don't see why this is necessary, as it will already flag a warning if the subject and the attachment don't match, whoever the message is sent to. Other attachments are unaffected. By adding the sender distribution list to the mix, you increase the danger of sending a message to the wrong person, rather than reduce it.

SerenityNetworks · #2 03-19-2016, 07:38 AM

Quote:

Originally Posted by gmayor

...By adding the sender distribution list to the mix, you increase the danger of sending a message to the wrong person, rather than reduce it.

I'm not following. I would want this to be an "and". That is, the "To" AND "Subject" AND 'attachment name' must all match. Unless all three match up then it doesn't send.

Thanks,
Andrew

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