--- description: When you create or change an appointment in Outlook calendar, Outlook will auto check if there are any conflicting appointments. At this time, if you wish to check the conflicts, you can use the method introduced in this post. title: How to Quickly Find out All Other Appointments Conflicting with a Specific Appointment in Outlook image: https://www.datanumen.com/blogs/wp-content/uploads/2017/07/quickly-find-out-all-other-appointments-conflicting-with-a-specific-appointment-in-outlook.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 Quickly Find out All Other Appointments Conflicting with a Specific Appointment in Outlook # How to Quickly Find out All Other Appointments Conflicting with a Specific Appointment in Outlook [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) September 29, 2025 Share Now: - - - - - - - - *When you create or change an appointment in Outlook calendar, Outlook will auto check if there are any conflicting appointments. At this time, if you wish to check the conflicts, you can use the method introduced in this post.* Perhaps you have ever seen the “Conflicts with another appointment” text when creating or altering an Outlook appointment. It’s because that Outlook can auto check the conflicts. However, Outlook cannot help you to find the conflicts quickly by its default features. Thus, here we’ll tell you a method to generate the function to search all conflicting appointments. ![Quickly Find out All Other Appointments Conflicting with a Specific Appointment in Outlook](https://www.datanumen.com/blogs/wp-content/uploads/2017/07/quickly-find-out-all-other-appointments-conflicting-with-a-specific-appointment-in-outlook.jpg "Quickly Find out All Other Appointments Conflicting with a Specific Appointment in Outlook") ## Find out All Other Appointments Conflicting with a Specific Appointment 1. At the very outset, launch your Outlook program. 2. Then, in Outlook main window, press “Alt + F11” key buttons. 3. At once, you will access the Outlook VBA editor, in which you need to open an unused module. 4. Next, copy the following VBA code into this module. ``` Sub FindOutConflictingAppointments() Dim objAppointment As AppointmentItem Dim dStartTime, dEndTime As Date Dim strFilter As String Dim objAppointments As Items Dim objFoundAppointments As Items Dim objItem As AppointmentItem Dim i As Long Dim strConflicts As String Dim strMsg As String Select Case Application.ActiveWindow.Class Case olExplorer Set objAppointment = Application.ActiveExplorer.Selection(1) Case olInspector Set objAppointment = Application.ActiveInspector.CurrentItem End Select dStartTime = objAppointment.start dEndTime = objAppointment.End Set objAppointments = Application.ActiveExplorer.CurrentFolder.Items i = 1 '1: Find all appts whose end time within the start and end time of source appt strFilter = "[End] >= " & Chr(34) & Format(dStartTime, "mm/dd/yyyy hh:mm AMPM") & Chr(34) & " AND [End] <= " & Chr(34) & Format(dEndTime, "mm/dd/yyyy hh:mm AMPM") & Chr(34) Set objFoundAppointments = objAppointments.Restrict(strFilter) For Each objItem In objFoundAppointments If objItem.Subject <> objAppointment.Subject Then strConflicts = strConflicts & i & ". " & objItem.Subject & vbCrLf i = i + 1 End If Next '2: Find all appts occurring within the start and end time of source appt strFilter = "[Start] >= " & Chr(34) & Format(dStartTime, "mm/dd/yyyy hh:mm AMPM") & Chr(34) & " AND [End] <= " & Chr(34) & Format(dEndTime, "mm/dd/yyyy hh:mm AMPM") & Chr(34) Set objFoundAppointments = objAppointments.Restrict(strFilter) For Each objItem In objFoundAppointments If objItem.Subject <> objAppointment.Subject Then strConflicts = strConflicts & i & ". " & objItem.Subject & vbCrLf i = i + 1 End If Next '3: Find all appts whose start time within the start and end time of source appt strFilter = "[Start] >= " & Chr(34) & Format(dStartTime, "mm/dd/yyyy hh:mm AMPM") & Chr(34) & " AND [Start] <= " & Chr(34) & Format(dEndTime, "mm/dd/yyyy hh:mm AMPM") & Chr(34) Set objFoundAppointments = objAppointments.Restrict(strFilter) For Each objItem In objFoundAppointments If objItem.Subject <> objAppointment.Subject Then strConflicts = strConflicts & i & ". " & objItem.Subject & vbCrLf i = i + 1 End If Next '4: Find all appts cover the entire source appt strFilter = "[Start] <= " & Chr(34) & Format(dStartTime, "mm/dd/yyyy hh:mm AMPM") & Chr(34) & " AND [End] >= " & Chr(34) & Format(dEndTime, "mm/dd/yyyy hh:mm AMPM") & Chr(34) Set objFoundAppointments = objAppointments.Restrict(strFilter) For Each objItem In objFoundAppointments If objItem.Subject <> objAppointment.Subject Then strConflicts = strConflicts & i & ". " & objItem.Subject & vbCrLf i = i + 1 End If Next strMsg = i - 1 & " Conflicting Appointments:" & vbCrLf & vbCrLf & strConflicts MsgBox strMsg, vbInformation + vbOKOnly, "Check Conflicts" End Sub ``` ![VBA Code - Find out All Other Appointments Conflicting with a Specific Appointment]( "VBA Code - Find out All Other Appointments Conflicting with a Specific Appointment") 5. After that, you could exit the current window. 6. Then add this macro to Quick Access Toolbar as usual. 7. Later you also should insure that macros are enabled in your Outlook. Just go to “Macro Setting” to check it. 8. Finally you can have a try. - Firstly, select or open an appointment, in which there is a “Conflicts with another appointment” prompt. - Then click on the macro button in Quick Access Toolbar. - At once, you will get a message that is listing all conflicting appointments, shown as the following screenshot:![Message that is listing all conflicting appointments]( "Message that is listing all conflicting appointments") ## Essential Precautions before Outlook Corruption It is known that Outlook is prone to crash and suffer errors. Thus, it is a matter of necessity to keep well-prepared for Outlook corruption. One of the most essential precautions is the periodic backup. In addition, it’s suggested to prepare a potent specialized [Outlook repair](https://www.datanumen.com/outlook-repair/) tool, like DataNumen Outlook Repair. ## Author Introduction: Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [mdf 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/2-methods-auto-set-status-day-event-busy-outlook/) [Next post →](https://www.datanumen.com/blogs/5-ways-quickly-remove-bullets-list-numbers-word-document/) 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\/quickly-find-appointments-conflicting-specific-appointment-outlook\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-find-appointments-conflicting-specific-appointment-outlook\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Quickly Find out All Other Appointments Conflicting with a Specific Appointment in Outlook","datePublished":"2017-07-31T01:17:13+00:00","dateModified":"2025-09-29T10:39:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-find-appointments-conflicting-specific-appointment-outlook\/"},"wordCount":349,"commentCount":2,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-find-appointments-conflicting-specific-appointment-outlook\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/07\/quickly-find-out-all-other-appointments-conflicting-with-a-specific-appointment-in-outlook.jpg","articleSection":["Outlook Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/quickly-find-appointments-conflicting-specific-appointment-outlook\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/quickly-find-appointments-conflicting-specific-appointment-outlook\/","url":"https:\/\/www.datanumen.com\/blogs\/quickly-find-appointments-conflicting-specific-appointment-outlook\/","name":"How to Quickly Find out All Other Appointments Conflicting with a Specific Appointment in Outlook","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-find-appointments-conflicting-specific-appointment-outlook\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/quickly-find-appointments-conflicting-specific-appointment-outlook\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/07\/quickly-find-out-all-other-appointments-conflicting-with-a-specific-appointment-in-outlook.jpg","datePublished":"2017-07-31T01:17:13+00:00","dateModified":"2025-09-29T10:39:49+00:00","description":"When you create or change an appointment in Outlook calendar, Outlook will auto check if there are any conflicting appointments. At this time, if you wish to check the conflicts, you can use the method introduced in this post.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/quickly-find-appointments-conflicting-specific-appointment-outlook\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/quickly-find-appointments-conflicting-specific-appointment-outlook\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/07\/quickly-find-out-all-other-appointments-conflicting-with-a-specific-appointment-in-outlook.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/07\/quickly-find-out-all-other-appointments-conflicting-with-a-specific-appointment-in-outlook.jpg","width":1596,"height":1000,"caption":"Quickly Find out All Other Appointments Conflicting with a Specific Appointment in Outlook"},{"@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\/"]}]} ```