Outlook：如何删除重复日历项

有时从其他设备导入事件后，日历中可能会出现重复项。为帮助您删除这些重复日历项，本文将介绍两种方法：当重复项较少时，可以逐一手动删除；若重复项较多，则可通过 VBA 批量删除。

手动删除重复日历项（逐个操作）

使用 VBA 一次性删除重复日历项

---

手动删除重复日历项（逐个操作）

若需逐个删除重复的日历项，请先按特定顺序排列日历项，以便清晰查看重复内容，然后逐项删除。

1. 通常情况下，日历默认处于“日历”视图。激活您想要删除重复项的日历后，点击“视图”>“更改视图”>“列表”。

此时，日历已以列表方式呈现。

2. 接下来，指定一个用于判断日历项是否重复的条件，例如比较主题是否一致。点击日历列表中的“主题”，即可将所有主题相同的日历项集中显示。

3. 此时，您可以右键单击同一主题的日历项，在弹出的菜单中选择“删除”，逐一将这些项移除。

---

---

使用 VBA 一次性删除重复日历项

这里为您介绍几段 VBA 代码，适用于不同场景，一键清除日历文件夹中所有重复的日历项。

1. 请按下 “Alt”+“F11” 组合键，立即打开“Microsoft Visual Basic for Applications”窗口。

2. 点击“插入”>“模块”以新建一个空白模块，然后将以下代码复制粘贴到该模块中。

VBA：删除某一指定类别下的全部重复日历项

'Sub RemoveDuplicateCalendar()
'UpdatebyExtendoffice20220413
  Dim xStores As Stores
  Dim xStore As Store
  Dim xRootFolder As Folder
  Dim xFolder As Object
  Set xStores = Application.Session.Stores
  For Each xStore In xStores
    Set xRootFolder = xStore.GetRootFolder
    For Each xFolder In xRootFolder.Folders
      Call ProcessFolders(xFolder)
    Next
  Next
  Set xStores = Nothing
End Sub

Sub ProcessFolders(ByVal CurrentFld As Folder)
  Dim xDictionary As Object
  Dim i As Long
  Dim xItem As Object
  Dim xKey As String
  Dim xSubFld As Folder
  On Error Resume Next
  If CurrentFld.DefaultItemType <> olAppointmentItem Then Exit Sub
  Set xDictionary = CreateObject("Scripting.Dictionary")
  For i = CurrentFld.Items.Count To 1 Step -1
    Set xItem = CurrentFld.Items.Item(i)
    'change categories as you need in below script
    If xItem.Categories = "date" Then
    'change the comparing items as you need
      xKey = xItem.Subject & xItem.Location & xItem.Body & xItem.Categories
      If xDictionary.Exists(xKey) = True Then
        xItem.Delete
      Else
        xDictionary.Add xKey, True
      End If
    End If
  Next i
  For Each xSubFld In CurrentFld.Folders
    ProcessFolders xSubFld
  Next
End Sub

此 VBA 通过对主题、地点、正文和类别进行比对，删除“date”类别中的所有重复项。您可根据需要自行调整比对条件。

3. 然后按下“F5” 键或点击“运行”即可执行代码，此时会弹出“宏”对话框，选择“RemoveDuplicateCalendar”并点击“运行”。

此时，“date”类别下的重复日历项已成功移除。

VBA：跨类别删除所有重复日历项

Sub RemoveDuplicateCalendar()
'UpdatebyExtendoffice20220413
  Dim xStores As Stores
  Dim xStore As Store
  Dim xRootFolder As Folder
  Dim xFolder As Object
  Set xStores = Application.Session.Stores
  For Each xStore In xStores
    Set xRootFolder = xStore.GetRootFolder
    For Each xFolder In xRootFolder.Folders
      Call ProcessFolders(xFolder)
    Next
  Next
  Set xStores = Nothing
End Sub

Sub ProcessFolders(ByVal CurrentFld As Folder)
  Dim xDictionary As Object
  Dim i As Long
  Dim xItem As Object
  Dim xKey As String
  Dim xSubFld As Folder
  On Error Resume Next
  If CurrentFld.DefaultItemType <> olAppointmentItem Then Exit Sub
  Set xDictionary = CreateObject("Scripting.Dictionary")
  For i = CurrentFld.Items.Count To 1 Step -1
    Set xItem = CurrentFld.Items.Item(i)
    'change the comparing items as you need
      xKey = xItem.Subject & xItem.Location & xItem.Body & xItem.Categories
      If xDictionary.Exists(xKey) = True Then
        xItem.Delete
      Else
        xDictionary.Add xKey, True
      End If
  Next i
  For Each xSubFld In CurrentFld.Folders
    ProcessFolders xSubFld
  Next
End Sub

运行此代码后，将自动清除每个类别下主题、地点、正文和类别完全相同的重复日历项。

注意：上述 VBA 适用于包含子文件夹的日历文件夹。