Outlook-da ma'lum bir uchrashuvga zid keladigan barcha boshqa uchrashuvlarni qanday tezda topish mumkin

Hozir ulashing:

Outlook taqvimida uchrashuv yaratganingizda yoki o'zgartirganingizda, Outlook bir-biriga zid bo'lgan uchrashuvlar bor-yo'qligini avtomatik ravishda tekshiradi. Hozirda, agar siz nizolarni tekshirmoqchi bo'lsangiz, ushbu postda taqdim etilgan usuldan foydalanishingiz mumkin.

Ehtimol, siz Outlook uchrashuvini yaratish yoki o'zgartirish paytida "Boshqa uchrashuv bilan ziddiyat" matnini ko'rgan bo'lishingiz mumkin. Buning sababi, Outlook avtomatik ravishda ziddiyatlarni tekshirishi mumkin. Biroq, Outlook o'zining standart xususiyatlari tufayli ziddiyatlarni tezda topishga yordam bera olmaydi. Shunday qilib, bu erda biz sizga barcha qarama-qarshi uchrashuvlarni qidirish funktsiyasini yaratish usulini aytib beramiz.

Outlook-da muayyan uchrashuvga zid keladigan barcha boshqa uchrashuvlarni tezda bilib oling

Muayyan uchrashuvga zid keladigan barcha boshqa uchrashuvlarni bilib oling

  1. Eng boshida Outlook dasturini ishga tushiring.
  2. Keyin, Outlook asosiy oynasida "Alt + F11" tugmachalarini bosing.
  3. Bir vaqtning o'zida siz foydalanilmagan modulni ochishingiz kerak bo'lgan Outlook VBA muharririga kirasiz.
  4. Keyin quyidagi VBA kodini ushbu modulga nusxalang.
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 kodi - Muayyan uchrashuvga zid keladigan barcha boshqa uchrashuvlarni bilib oling

  1. Shundan so'ng siz joriy oynadan chiqishingiz mumkin.
  2. Keyin ushbu makrosni odatdagidek Tez kirish asboblar paneliga qo'shing.
  3. Keyinchalik Outlook-da makrolar yoqilganligiga ishonch hosil qilishingiz kerak. Buni tekshirish uchun "Makro sozlamalari" ga o'ting.
  4. Nihoyat, siz sinab ko'rishingiz mumkin.
  • Birinchidan, "Boshqa uchrashuv bilan ziddiyat" so'rovi mavjud bo'lgan uchrashuvni tanlang yoki oching.
  • Keyin Tez kirish asboblar panelidagi makros tugmasini bosing.
  • Bir vaqtning o'zida siz quyidagi skrinshot sifatida ko'rsatilgan barcha qarama-qarshi uchrashuvlar ro'yxatini ko'rsatadigan xabarni olasiz:Barcha ziddiyatli uchrashuvlar ro'yxati keltirilgan xabar

Outlook korruptsiyasidan oldin asosiy ehtiyot choralari

Ma'lumki, Outlook ishdan chiqishga va xatolarga duch kelishga moyil. Shuning uchun Outlookning buzilishiga yaxshilab tayyorgarlik ko'rish zarur. Eng muhim ehtiyot choralaridan biri bu vaqti-vaqti bilan zaxira nusxasini yaratishdir. Bundan tashqari, kuchli ixtisoslashgan dasturni tayyorlash tavsiya etiladi. Outlook-ni ta'mirlash asbob, kabi DataNumen Outlook Repair.

Muallif kirish:

Shirli Chjan ma'lumotlarni qayta tiklash bo'yicha mutaxassis DataNumenMa'lumotlarni qayta tiklash texnologiyalari bo'yicha jahon yetakchisi bo'lgan , Inc mdf tiklash va Outlook ta'mirlash dasturiy mahsulotlar. Qo'shimcha ma'lumot olish uchun tashrif buyuring www.datanumen.com

Hozir ulashing:

Comments are closed.