Outlook 2013 - Compile list of all emails in certain category & display as pop up daily/weekly

Question

I need to find a way, either via VBA code/macro or some built in feature, to compile a list of all emails in the inbox that are assigned to a certain category (i.e. blue New Unread Emails) and then have that list pop up as a reminder either daily or weekly for the user to see all the emails they have to deal with which are marked as that category.

Another option is to take the same list and have it show up in the users inbox, again either daily or weekly, but marked with a different category (i.e. red To Do List) so that it stands out as they scroll through their inbox.

Marking the email a different category is pretty simple through outlooks rules, but compiling the list and having it sent to the user daily or weekly is the hard part.

Any and all help is greatly appreciated.

Thank you.

Answer 1

Hello Josh,

You can use the Find/FindNext or Restrict methods of the Items class to find a list of items that correspond to a condition. In case if you need to search through multiple folders, the AdvancedSearch method of the Application class can be found helpful. Read more about them in the following articles:

How To: Use Find and FindNext methods to retrieve Outlook mail items from a folder (C#, VB.NET)

How To: Use Restrict method to retrieve Outlook mail items from a folder

Advanced search in Outlook programmatically: C#, VB.NETAlso you may find the Getting Started with VBA in Outlook 2010 article helpful.

---

[custom.development]

Answer 2

>>>Marking the email a different category is pretty simple through outlooks rules, but compiling the list and having it sent to the user daily or weekly is the hard part.

According to your description, you could refer to below link about how to retrieve unread messages from Inbox:

How to retrieve unread messages from Inbox by using Outlook Object Model in Visual Basic .NET

Then you could send a schedule recurring email in Outlook, refer to below link:

https://www.extendoffice.com/documents/outlook/1567-outlook-send-schedule-recurring-email.html

Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.