I have an Outlook rule that check for incoming mail, when the mail is from
dcmonitor, with subject containing "NT Event Security" and mail body
containing the words "audit log is cleared", then move the the outlook folder
"Audit Log Cleared".
Now I want it to further call a Macro to process deletion if necessary
before moving to the "Audit Log Cleared" folder.
I have a list of servers that have scheduled job to do audit log clearing at
specified time and day of a week, the sample of the list:
Day Time Servers
Sun 00:01 SS203, SS204, SN404, SN203, SF1203, SL2311
Daily 03:20 SS111, SS320, SN23
Daily 04:21 SN434, SN34
Wed 01:20 SSN2333, SNL2
The list is very long, so tedious to just put these into the rule itself,
further the Outlook rule limitation on rule storage size will be reached.
Therefore I would to have a Macro that do the checking:
1. Look in the subject and look for string that matches any of the server
2. If the match is found check the date and time of the mail and see if the
corresponding day and time (allow time window of 1 hour) in the list matches.
3. If matches, delete the e-mail
4. If no match, exit.