--- description: If you are classifying Outlook meetings by color categories and want to set different reminder time for meetings in different color categories, you can refer to this article. Here we will teach you to realize it with Outlook VBA. title: How to Auto Set Different Reminder Time for Outlook Meetings in Different Color Categories image: https://www.datanumen.com/blogs/wp-content/uploads/2017/10/auto-set-different-reminder-time-for-meetings-in-different-color-categories.jpg --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) > How to Auto Set Different Reminder Time for Outlook Meetings in Different Color Categories # How to Auto Set Different Reminder Time for Outlook Meetings in Different Color Categories [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) September 29, 2025 Share Now: - - - - - - - - *If you are classifying Outlook meetings by color categories and want to set different reminder time for meetings in different color categories, you can refer to this article. Here we will teach you to realize it with Outlook VBA.* For instance, you are dividing meetings into two groups. One is in “Offsite” color category in that the meeting location is too far, and the other is in “Onsite” color category as the location is right here. Now, you want that Outlook can auto set the reminder time of “offsite” meeting as 1 hour before start and “onsite” meeting as 15 minute before start. Looking at this requirement, thereinafter, we will share a quick method. ![Auto Set Different Reminder Time for Outlook Meetings in Different Color Categories](https://www.datanumen.com/blogs/wp-content/uploads/2017/10/auto-set-different-reminder-time-for-meetings-in-different-color-categories.jpg "Auto Set Different Reminder Time for Outlook Meetings in Different Color Categories") ## Auto Set Different Reminder for Meetings in Different Color Categories 1. To begin with, launch your Outlook application. 2. Then, press “Alt + F11” key buttons to access VBA editor window. 3. Next, in the subsequent window, copy and paste the VBA code below into the “ThisOutlookSession” project. ``` Public WithEvents objCalendar As Outlook.Folder Public WithEvents objCalendarItems As Outlook.Items Private Sub Application_Startup() Set objCalendar = Outlook.Application.Session.GetDefaultFolder(olFolderCalendar) Set objCalendarItems = objCalendar.Items End Sub Private Sub objCalendarItems_ItemAdd(ByVal Item As Object) Call SetReminder_BasedOnCategories(Item) End Sub Private Sub objCalendarItems_ItemChange(ByVal Item As Object) Call SetReminder_BasedOnCategories(Item) End Sub Private Sub SetReminder_BasedOnCategories(ByVal objCalendarItem As Object) Dim objMeeting As Outlook.AppointmentItem Dim strCategories As String If objCalendarItem.Class = olAppointment Then 'Check if the item is a meeting If objCalendarItem.MeetingStatus = olMeeting Then Set objMeeting = objCalendarItem strCategories = objMeeting.Categories 'Set Reminder as 60 min before start for offsite appointments If InStr(strCategories, "Offsite") > 0 Then With objMeeting .ReminderSet = True .ReminderMinutesBeforeStart = 60 .Save End With 'Set Reminder as 15 min before start for onsite appointments ElseIf InStr(strCategories, "Onsite") > 0 Then With objMeeting .ReminderSet = True .ReminderMinutesBeforeStart = 15 .Save End With End If End If End If End Sub ``` ![VBA Code - Auto Set Different Reminder for Meetings in Different Color Categories]( "VBA Code - Auto Set Different Reminder for Meetings in Different Color Categories") 4. Later, you need click into the “Application\_Startup” subroutine and press “F5” key button to run this macro. 5. Since then, every time when a new meeting is added to the default calendar or you change an existing meeting, Outlook will auto check the categories of the meeting and auto set the different reminder time.![Different Reminder Time for Meetings in Different Color Categories]( "Different Reminder Time for Meetings in Different Color Categories") ## Eliminate Outlook Errors Various issues may occur to Outlook from time to time. Therefore, it is extremely important for users to learn how to cope with Outlook issues. For a start, you had better make regular Outlook data backups. Moreover, if affordable, it is suggested to keep a potent [Outlook repair](https://www.datanumen.com/outlook-repair/) tool nearby, such as DataNumen Outlook Repair. It can scan your PST file to figure out Outlook issues and then resolve them with ease. ## Author Introduction: Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [sql recovery](https://www.datanumen.com/sql-recovery/) and outlook repair software products. For more information visit [www.datanumen.com](https://www.datanumen.com/) Share Now: - - - - - - - - [← Previous post](https://www.datanumen.com/blogs/quickly-change-security-password-ms-access/) [Next post →](https://www.datanumen.com/blogs/6-solutions-corrupt-master-file-table-error-windows/) Comments are closed. ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.datanumen.com\/blogs\/auto-set-different-reminder-time-outlook-meetings-different-color-categories\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/auto-set-different-reminder-time-outlook-meetings-different-color-categories\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Auto Set Different Reminder Time for Outlook Meetings in Different Color Categories","datePublished":"2017-10-28T03:25:37+00:00","dateModified":"2025-09-29T09:12:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/auto-set-different-reminder-time-outlook-meetings-different-color-categories\/"},"wordCount":335,"commentCount":2,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/auto-set-different-reminder-time-outlook-meetings-different-color-categories\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/10\/auto-set-different-reminder-time-for-meetings-in-different-color-categories.jpg","articleSection":["Outlook Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/auto-set-different-reminder-time-outlook-meetings-different-color-categories\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/auto-set-different-reminder-time-outlook-meetings-different-color-categories\/","url":"https:\/\/www.datanumen.com\/blogs\/auto-set-different-reminder-time-outlook-meetings-different-color-categories\/","name":"How to Auto Set Different Reminder Time for Outlook Meetings in Different Color Categories","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/auto-set-different-reminder-time-outlook-meetings-different-color-categories\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/auto-set-different-reminder-time-outlook-meetings-different-color-categories\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/10\/auto-set-different-reminder-time-for-meetings-in-different-color-categories.jpg","datePublished":"2017-10-28T03:25:37+00:00","dateModified":"2025-09-29T09:12:33+00:00","description":"If you are classifying Outlook meetings by color categories and want to set different reminder time for meetings in different color categories, you can refer to this article. Here we will teach you to realize it with Outlook VBA.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/auto-set-different-reminder-time-outlook-meetings-different-color-categories\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/auto-set-different-reminder-time-outlook-meetings-different-color-categories\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/10\/auto-set-different-reminder-time-for-meetings-in-different-color-categories.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/10\/auto-set-different-reminder-time-for-meetings-in-different-color-categories.jpg","width":2000,"height":1449,"caption":"Auto Set Different Reminder Time for Outlook Meetings in Different Color Categories"},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]},{"@type":"Person","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957","name":"AuthorCCW","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","caption":"AuthorCCW"},"sameAs":["https:\/\/www.datanumen.com\/"]}]} ```