This code monitors a series of mailboxes every 15 minutes and mails a message to the specified address if any of the mailboxes has a mail message in it.
My thanks to the people at UtterAccess.com for helping me clean it up.
The mail must be set up with a Main Mailbox and subordinate folders directly under the Inbox for the Main Mailbox.
For example:
[email protected] is the main mailbox and Folder 1, Folder 2 and Folder 3 are the subordinate mailboxes.Please Login or Register to view this content.
In my case I have a shared mailbox called Projects and I use filter rules to move incoming mail to the subordinate folders. This program keeps an eye on the subordinate folders and lets me know how many emails are in each of them and if none of them has mail then no message is sent.
The code was developed from several different sources which explains why the Alert Part and the actual Mail Part are in two different subroutines and not integrated. There is some configuration required and these parts of the code are shown in red.
Note: you may have to go to the Trust Center settings to "ease off" on the security. I have mine set to prompt me to accept the macro.
Add this code to THisOutlookSessionPlease Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks