使用python连接到outlook并读取电子邮件和附件，然后将其写入输出文件

import win32com.client
import pandas as pd
import pytz
from datetime import datetime
from dateutil import parser

outlook = win32com.client.Dispatch("Outlook.Application").GetNamespace("MAPI")

inbox = outlook.GetDefaultFolder(6)  # 6表示收件箱

emails = inbox.Items

data = pd.DataFrame(columns=['Subject', 'Sender', 'Received Time', 'Attachment Name', 'Attachment Path'])

for email in emails:
    subject = email.Subject
    sender = email.SenderName
    received_time = email.ReceivedTime
    attachments = email.Attachments

    for attachment in attachments:
        attachment_name = attachment.FileName
        attachment_path = "输出文件夹路径/" + attachment_name  # 替换为实际的输出文件夹路径

        attachment.SaveAsFile(attachment_path)

        data = data.append({'Subject': subject, 'Sender': sender, 'Received Time': received_time,
                            'Attachment Name': attachment_name, 'Attachment Path': attachment_path},
                           ignore_index=True)

output_file = "输出文件路径.csv"  # 替换为实际的输出文件路径
data.to_csv(output_file, index=False)