+ Reply to Thread
Results 1 to 2 of 2

Mailbox Monitoring Program (Outlook)

  1. #1
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Mailbox Monitoring Program (Outlook)

    Part of my job is to consolidate reports sent by other people in the company. I have a common mailbox set up for this purpose and use Outlook filter rules to sort them out into project folders, each directly under the common mailbox folder Inbox. This common mailbox is "below the fold" on my Outlook screen, so it is inconvenient to scroll down to check them constantly. Furthermore, in some cases, I have to wait for more than one person to send a report to me and can't process a report until the whole set has come in.

    So I developed a program to check these folders for me and send me a message with how many items are in each folder every 15 minutes. If there is nothing to report, then no message is sent. It makes the mailbox a bit busy in the morning as people start sending things in, but pays big dividends when that one report I expected in the morning doesn't come in until mid-afternoon. I'm not checking for it all day and I am alerted as soon as it comes in.

    It also serves as "nagware" to let me know I still have reports that need to be attended to.

    The attached archive has three files:
    • A text file to copy and paste into the ThisOutlookSession Module
    • A text file to copy and paste into a regular module
    • A Word Document with configuration instructions

    The program should be installable and configurable by people with basic VB skills.
    Attached Files Attached Files
    Last edited by dflak; 12-17-2018 at 04:06 PM.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Mailbox Monitoring Program (Outlook)

    Found an error with turning on / off the log file.

    Use this version.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Outlook - Monitor Mailbox and Alert if mail is there.
    By dflak in forum Tips and Tutorials
    Replies: 0
    Last Post: 10-02-2018, 02:20 PM
  2. Help Regarding Designing Monitoring Program in Excel
    By AzharNadeem in forum Excel General
    Replies: 16
    Last Post: 12-29-2014, 07:02 PM
  3. [SOLVED] Show newl message envelop notification for all mailbox/shared mailbox added in outlook
    By Goku in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 07-04-2014, 01:23 PM
  4. Macro to send outlook email from a different mailbox
    By naveenrv in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-25-2013, 05:11 PM
  5. Reference shared Outlook mailbox
    By arneld in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2012, 08:29 PM
  6. Outlook Mailbox Recieved Total
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2008, 11:28 PM
  7. Excel97 macro to archive Outlook mailbox
    By Geo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2005, 05:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1