Skip to main content

如何在Outlook中為所有未回覆的郵件創建搜索文件夾?

Author: Xiaoyang Last Modified: 2025-05-12

如果您想檢查Outlook中的未回覆郵件,逐一手動搜索將會花費大量時間。本文將介紹如何為所有未回覆的郵件創建一個搜索文件夾。

使用VBA代碼在Outlook中創建未回覆郵件的搜索文件夾


使用VBA代碼在Outlook中創建未回覆郵件的搜索文件夾

以下VBA代碼可以幫助您創建一個搜索文件夾,並將所有未回覆的郵件放入其中,請按照以下步驟操作:

1. 按住 ALT + F11 鍵打開 Microsoft Visual Basic for Applications 窗口。

2. 點擊 插入 > 模組,然後將以下宏粘貼到模組窗口中。

VBA代碼:為未回覆郵件創建搜索文件夾:

Sub CreateSearchFolder_AllNotRepliedEmails()
    Dim xSearch As Outlook.Search
    Dim xScope As String, xFilter As String
    Dim xRepliedProperty As String
    Dim xFolder As Folder, xSubFolder As Folder
    On Error Resume Next
    xScope = ""
    For Each xFolder In Outlook.Application.Session.Folders
        Set xSubFolder = xFolder.Folders("Inbox")
        xScope = "'" + xSubFolder.FolderPath + "'"
        xRepliedProperty = "http://schemas.microsoft.com/mapi/proptag/0x10810003"
        xFilter = Chr(34) & xRepliedProperty & Chr(34) & " <> 102" & "AND" & Chr(34) & xRepliedProperty & Chr(34) & " <> 103"
        Set xSearch = Outlook.Application.AdvancedSearch(Scope:=xScope, Filter:=xFilter, SearchSubFolders:=True, Tag:="SearchFolder")
        xSearch.Save("Not Replied Emails").ShowItemCount = olShowTotalItemCount
        Set xSearch = Nothing
        Set xSubFolder = Nothing
    Next
    MsgBox "Search folder is created successfully!", vbInformation + vbOKOnly, "Kutools for Outlook"
End Sub

3. 接著,按下 F5 鍵運行此代碼,隨後會彈出一個提示框,如下圖所示:

doc search folder for unreplied 1

4. 點擊 確定 按鈕,現在您會在每個帳戶的 搜索文件夾 下看到一個 未回覆郵件 文件夾,並且所有未回覆的郵件都會顯示在此處,請參見截圖:

doc search folder for unreplied 2