跳至主要内容

如何在Outlook中为所有未回复的邮件创建搜索文件夹?

Author: Xiaoyang Last Modified: 2025-05-07

如果您想查看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