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.

Muayyan uchrashuvga zid keladigan barcha boshqa uchrashuvlarni bilib oling
- Eng boshida Outlook dasturini ishga tushiring.
- Keyin, Outlook asosiy oynasida "Alt + F11" tugmachalarini bosing.
- Bir vaqtning o'zida siz foydalanilmagan modulni ochishingiz kerak bo'lgan Outlook VBA muharririga kirasiz.
- 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
- Shundan so'ng siz joriy oynadan chiqishingiz mumkin.
- Keyin ushbu makrosni odatdagidek Tez kirish asboblar paneliga qo'shing.
- Keyinchalik Outlook-da makrolar yoqilganligiga ishonch hosil qilishingiz kerak. Buni tekshirish uchun "Makro sozlamalari" ga o'ting.
- 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:
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

