none
Setup email alert if inbox has x amount of items RRS feed

  • Question

  • Hi I was wounding how to setup alert be send to the distribution group "x" if the number of emails in the y mailbox gets over over 50 or 100 emails?
    Wednesday, July 29, 2020 2:34 PM

All replies

  • Create a VBA script or a COM addin that sets up an event sink on the Items collection of the Inbox folder (retrieved from Application.Session.GetDefaultFolder(olFolderInbox) ). In the Items.ItemAdd event handler, check the number of items in the collection (Items.Count) and create a new message (Application.CreateItem), populate its properties, and send it.

    Dmitry Streblechenko (MVP)
    http://www.dimastr.com/redemption
    Redemption - what the Outlook
    Object Model should have been
    Version 5.5 is now available!

    Wednesday, July 29, 2020 10:13 PM
  • Hello Dmitry ,

    Thank you for your response.

    I am not very good with VBA could you help me write it or provide me an example how it should look?

    Sorry in advance 

    Thursday, July 30, 2020 11:52 AM