PYTHON 邮件内容添加到EXCEL附件

好的，以下是一个示例代码，可以将邮件内容添加到 Excel 文件中，并将其作为附件发送出去：

import imaplib
import email
from openpyxl import load_workbook
import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.application import MIMEApplication

# 连接邮箱服务器
mail = imaplib.IMAP4_SSL('imap.163.com')
mail.login('your_email', 'your_password')
mail.select()

# 获取邮件
typ, data = mail.search(None, 'ALL')
for num in data[0].split():
    typ, data = mail.fetch(num, '(RFC822)')
    msg = email.message_from_bytes(data[0][1])

    # 解析邮件内容，提取需要的信息
    # ...

    # 打开 Excel 文件，将信息写入
    wb = load_workbook('your_excel_file.xlsx')
    ws = wb.active
    ws.append(['info1', 'info2', 'info3'])
    wb.save('your_excel_file.xlsx')

    # 发送邮件
    from_email = 'your_email'
    to_email = 'recipient_email'

    msg = MIMEMultipart()
    msg['From'] = from_email
    msg['To'] = to_email
    msg['Subject'] = 'Mail with Excel attachment'

    # 添加邮件正文
    body_text = 'Please see the attached Excel file for more information.'
    body = MIMEText(body_text, 'html')
    msg.attach(body)

    # 添加 Excel 文件作为附件
    with open('your_excel_file.xlsx', 'rb') as f:
        part = MIMEApplication(f.read(), Name='your_excel_file.xlsx')
        part['Content-Disposition'] = 'attachment; filename="your_excel_file.xlsx"'
        msg.attach(part)

    # 发送邮件
    server = smtplib.SMTP('smtp.163.com', 25)
    server.login('your_email', 'your_password')
    server.sendmail(from_email, to_email, msg.as_string())
    server.quit()

# 关闭连接
mail.close()
mail.logout()

需要注意的是，示例中的邮件服务器和账号密码信息需要您根据实际情况进行修改。另外，具体的邮件内容解析和 Excel 文件写入方法需要根据实际情况进行编写。