使用win32com.client通过Message-ID在Outlook中移邮件遇查找失败问题

针对你遇到的问题，以下是几个可行的排查和修复方案：

1. 确认Message-ID的实际存储格式 #

Outlook中存储的Message-ID可能和你从界面或控制台拿到的格式不一致（比如是否包含尖括号<>、大小写差异、额外空格等）。可以先添加代码打印源文件夹中邮件的实际Message-ID，对比你传入的msg_id：

def move_email_by_message_id(self, from_folder, to_folder, msg_id):
    try:
        source_folder = self.outlook.GetNamespace("MAPI").Folders(self.username).Folders(from_folder)
        target_folder = self.outlook.GetNamespace("MAPI").Folders(self.username).Folders(to_folder)

        # 打印源文件夹中所有邮件的Message-ID，用于对比格式
        for item in source_folder.Items:
            if item.Class == 43:  # 仅处理邮件类型（Outlook中邮件的Class值为43）
                stored_msg_id = item.PropertyAccessor.GetProperty('http://schemas.microsoft.com/mapi/proptag/0x0037001F')
                print(f"Stored Message-ID: {stored_msg_id}")
                print(f"Your input msg_id: {msg_id}")

        # 原查找逻辑...
    except Exception as e:
        print("Error:", e)

运行后对比两者格式，确保传入的msg_id和存储的完全一致（包括尖括号、大小写）。

2. 使用MAPI属性标签替代httpmail命名空间 #

urn:schemas:httpmail:message-id有时会出现匹配问题，改用MAPI原生的PR_INTERNET_MESSAGE_ID属性标签（0x0037001F）更可靠。同时处理Message-ID中的单引号转义（避免SQL语法错误）：

def move_email_by_message_id(self, from_folder, to_folder, msg_id):
    try:
        source_folder = self.outlook.GetNamespace("MAPI").Folders(self.username).Folders(from_folder)
        target_folder = self.outlook.GetNamespace("MAPI").Folders(self.username).Folders(to_folder)

        # 转义Message-ID中的单引号（SQL语法要求单引号用两个单引号表示）
        escaped_msg_id = msg_id.replace("'", "''")
        # 使用MAPI属性标签构建精确匹配的筛选条件
        filter_str = f"@SQL=http://schemas.microsoft.com/mapi/proptag/0x0037001F = '{escaped_msg_id}'"
        items = source_folder.Items.Restrict(filter_str)

        # 遍历确认匹配项（避免Items.Count不准确的问题）
        moved = False
        for item in items:
            item.Move(target_folder)
            print(f"Email with Message-ID '{msg_id}' moved from '{from_folder}' to '{to_folder}' folder.")
            moved = True
            break
        if not moved:
            print(f"Email with Message-ID '{msg_id}' not found in '{from_folder}'.")

    except Exception as e:
        print("Error:", e)

3. 改用遍历查找作为备选方案 #

如果Restrict方法仍然失效，可以直接遍历源文件夹中的邮件进行匹配（适合文件夹内邮件数量不多的场景）：

def move_email_by_message_id(self, from_folder, to_folder, msg_id):
    try:
        source_folder = self.outlook.GetNamespace("MAPI").Folders(self.username).Folders(from_folder)
        target_folder = self.outlook.GetNamespace("MAPI").Folders(self.username).Folders(to_folder)

        moved = False
        for item in source_folder.Items:
            if item.Class == 43:  # 仅处理邮件
                stored_msg_id = item.PropertyAccessor.GetProperty('http://schemas.microsoft.com/mapi/proptag/0x0037001F')
                if stored_msg_id == msg_id:
                    item.Move(target_folder)
                    print(f"Email with Message-ID '{msg_id}' moved successfully.")
                    moved = True
                    break
        if not moved:
            print(f"Email with Message-ID '{msg_id}' not found in '{from_folder}'.")

    except Exception as e:
        print("Error:", e)

内容的提问来源于stack exchange，提问作者Abin Jilson