Hi Carl, let's tackle that frustrating COM error you're running into. The "-2147221005 Invalid class string" message almost always stems from issues with how your Python script is accessing Outlook's COM object. Let's break down the fixes and share a revised, robust version of your code.

Common Causes & Quick Fixes #

• Outlook isn't running or installed: You need the desktop version of Outlook (not just the web app) running in the background with your account logged in. If you just installed Outlook, restart your PC to ensure COM registration completes.
• 32/64 bit mismatch: This is a super common culprit. If you have 64-bit Outlook installed, you must use 64-bit Python (and vice versa for 32-bit). Check your Outlook version via File > Account > About Outlook, and verify your Python bitness with python --version (it'll show 32/64 in the output).
• Permission issues: Try running your Python IDE or command prompt as an administrator—sometimes Outlook's COM object requires elevated access to be accessed.

Revised Code with Error Handling & Attachment Download Logic #

Here's a polished version of your script that fixes common pitfalls, adds subject filtering, and handles attachments properly:

import win32com.client
import os

def download_outlook_attachments(subject_filter=None, save_path=None):
    # Set default save path to current working directory if not provided
    save_path = save_path or os.getcwd()
    # Create save directory if it doesn't exist
    if not os.path.exists(save_path):
        os.makedirs(save_path)

    try:
        # Initialize Outlook COM object
        outlook_app = win32com.client.Dispatch("Outlook.Application")
        mapi_namespace = outlook_app.GetNameSpace("MAPI")
        inbox = mapi_namespace.GetDefaultFolder(6)  # 6 corresponds to the Inbox folder
        messages = inbox.Items

        # Filter messages by subject if a filter is provided
        if subject_filter:
            # Use Restrict for efficient filtering (case-insensitive)
            filter_query = f"[Subject] LIKE '%{subject_filter}%'"
            messages = messages.Restrict(filter_query)

        # Iterate through matching messages and download attachments
        for msg in messages:
            # Skip non-mail items (like meeting requests)
            if msg.Class != 43:
                continue
            
            print(f"Processing email: {msg.Subject}")
            for attachment in msg.Attachments:
                # Skip embedded attachments (e.g., signature images) - remove this if you want all attachments
                if attachment.Type == 1:
                    continue
                
                attachment_path = os.path.join(save_path, attachment.FileName)
                attachment.SaveAsFile(attachment_path)
                print(f"Successfully downloaded: {attachment_path}")

    except Exception as e:
        print(f"Error encountered: {str(e)}")
        print("\nTroubleshooting tips:")
        print("- Ensure Outlook desktop app is running and logged in")
        print("- Check for 32/64 bit match between Python and Outlook")
        print("- Try running your script as administrator")

# Example usage: Download attachments from emails with "Invoice" in the subject
download_outlook_attachments(subject_filter="Invoice")

Key Improvements in This Code #

• Efficient filtering: Uses Outlook's Restrict method instead of manually checking each message's subject—this is way faster for large inboxes.
• Error handling: Catches exceptions and provides actionable troubleshooting tips.
• Attachment type filtering: Skips embedded attachments (like signature images) to avoid clutter—remove that check if you need to save every attachment.
• Path safety: Ensures the save directory exists before trying to save files.

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