--- description: In this article, we will show you how to batch change the reminder time of multiple appointments with Outlook VBA codes. title: Batch Change the Reminder Time of Multiple Appointments with VBA image: https://www.datanumen.com/blogs/wp-content/uploads/2018/05/vba-code-batch-change-reminders.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 Batch Change the Reminder Time of Multiple Appointments with Outlook VBA # How to Batch Change the Reminder Time of Multiple Appointments with Outlook VBA [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) September 29, 2025 Share Now: - - - - - - - - *If you frequently need change the reminder time of multiple appointments, this article will be considerably helpful to you. The method here will effectively save you from manually changing the reminder time one by one.* The previous article – “ [3 Steps to Create & Change Reminders for Calendar Items in Batches](https://www.datanumen.com/blogs/3-steps-create-change-reminders-calendar-items-batches/)” has shared a method to bulk change many appointments’ reminder time. Yet, it still demands you to firstly change the view settings and then change one appointment’s reminder manually. Therefore, here we will introduce you a much more effective way. Here we will show the detailed steps and concrete VBA code. Hence, you don’t need to worry about having no knowledge about VBA. Just read on. ## Batch Change the Reminder Time of Multiple Appointments 1. At the very beginning, start Outlook program. 2. Then, access VBA editor with reference to “ [How to Run VBA Code in Your Outlook](https://www.datanumen.com/blogs/run-vba-code-outlook/)“. 3. Next, copy and paste the following VBA code into an unused module. ``` Sub BatchChangeRemindersMultipleAppointments() Dim lReminderMinBeforeStart As Long Dim objSelection As Outlook.Selection Dim i As Long Dim objAppointment As Outlook.AppointmentItem 'Enter the number of minutes the reminder should occur prior to the start of the appointment lReminderMinBeforeStart = InputBox("Enter the reminder minutes before start:", , "45") Set objSelection = Outlook.ActiveExplorer.Selection For i = objSelection.Count To 1 Step -1 If TypeOf objSelection.Item(i) Is AppointmentItem Then Set objAppointment = objSelection.Item(i) 'Enable the reminder If objAppointment.ReminderSet = False Then With objAppointment .ReminderSet = True .Save End With End If With objAppointment .ReminderMinutesBeforeStart = lReminderMinBeforeStart .Save End With End If Next 'Prompt you of "Complete" MsgBox "Complete!", vbInformation + vbOKOnly End Sub ``` ![VBA Code - Batch Change the Reminder Time of Multiple Appointments](<> "VBA Code - Batch Change the Reminder Time of Multiple Appointments") 4. After that, add this macro to ribbon or Quick Access Toolbar. 5. Finally, you can try it. - To begin with, select the appointments that you want. - Then, click the macro button.![Run Macro on Selected Appointments](<> "Run Macro on Selected Appointments") - Next, in popup dialog box, enter the number of reminder minutes before appointment start.![Enter the Reminder Minutes Before Item Start](<> "Enter the Reminder Minutes Before Item Start") - Now, you can check the reminder time of the selected appointments, which have been modified to your desire.![Changed Reminder Time](<> "Changed Reminder Time") ## Eliminate Outlook Errors If you frequently encounter miscellaneous errors in Outlook, you ought to make some robust measures. For instance, you need to back up your Outlook PST file at once, scan the file for viruses and killing them, learn how to effectively employ Scanpst to [fix PST](https://www.datanumen.com/outlook-repair/) issues and get hold of an external fix tool, such as DataNumen Outlook Repair. It will come in handy when you encounter troublesome problems which cannot be coped with by the inbox repair tool. ## Author Introdzction: Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [sql fix](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/how-to-quickly-create-an-outlook-rule-to-block-the-senders-of-multiple-emails/) [Next post →](https://www.datanumen.com/blogs/how-to-auto-use-different-font-colors-for-replying-and-forwarding-emails-with-outlook-vba/) 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\/how-to-batch-change-the-reminder-time-of-multiple-appointments-with-outlook-vba\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-batch-change-the-reminder-time-of-multiple-appointments-with-outlook-vba\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Batch Change the Reminder Time of Multiple Appointments with Outlook VBA","datePublished":"2018-05-16T05:43:41+00:00","dateModified":"2025-09-29T05:54:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-batch-change-the-reminder-time-of-multiple-appointments-with-outlook-vba\/"},"wordCount":352,"commentCount":1,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-batch-change-the-reminder-time-of-multiple-appointments-with-outlook-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/05\/vba-code-batch-change-reminders.jpg","articleSection":["Outlook Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/how-to-batch-change-the-reminder-time-of-multiple-appointments-with-outlook-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/how-to-batch-change-the-reminder-time-of-multiple-appointments-with-outlook-vba\/","url":"https:\/\/www.datanumen.com\/blogs\/how-to-batch-change-the-reminder-time-of-multiple-appointments-with-outlook-vba\/","name":"Batch Change the Reminder Time of Multiple Appointments with VBA","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-batch-change-the-reminder-time-of-multiple-appointments-with-outlook-vba\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-batch-change-the-reminder-time-of-multiple-appointments-with-outlook-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/05\/vba-code-batch-change-reminders.jpg","datePublished":"2018-05-16T05:43:41+00:00","dateModified":"2025-09-29T05:54:35+00:00","description":"In this article, we will show you how to batch change the reminder time of multiple appointments with Outlook VBA codes.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/how-to-batch-change-the-reminder-time-of-multiple-appointments-with-outlook-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/how-to-batch-change-the-reminder-time-of-multiple-appointments-with-outlook-vba\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/05\/vba-code-batch-change-reminders.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/05\/vba-code-batch-change-reminders.jpg","width":836,"height":454,"caption":"VBA Code - Batch Change the Reminder Time of Multiple Appointments"},{"@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\/"]}]} ```