如何将多个excel文件发送到Outlook中的多个组？

import pandas as pd
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart

# 读取多个Excel文件并合并为一个数据框
df = pd.concat([pd.read_excel('file1.xlsx'), pd.read_excel('file2.xlsx'), pd.read_excel('file3.xlsx')])

# 连接到SMTP服务器
smtp_server = 'smtp.example.com'
smtp_port = 587
smtp_username = 'your_email@example.com'
smtp_password = 'your_password'
smtp_connection = smtplib.SMTP(smtp_server, smtp_port)
smtp_connection.starttls()
smtp_connection.login(smtp_username, smtp_password)

# 遍历数据框的每一行，发送邮件给每个组的收件人
for index, row in df.iterrows():
    group_name = row['Group']
    recipient_emails = row['Emails'].split(',')
    
    # 创建邮件对象
    message = MIMEMultipart()
    message['Subject'] = 'Excel Files for {}'.format(group_name)
    message['From'] = smtp_username
    message['To'] = ', '.join(recipient_emails)
    
    # 设置邮件正文
    message.attach(MIMEText('Please find attached the Excel files for {}.'.format(group_name), 'plain'))
    
    # 添加附件
    for file_path in ['file1.xlsx', 'file2.xlsx', 'file3.xlsx']:
        with open(file_path, 'rb') as attachment:
            part = MIMEBase('application', 'octet-stream')
            part.set_payload(attachment.read())
            part.add_header('Content-Disposition', 'attachment', filename=file_path)
            message.attach(part)
    
    # 发送邮件
    smtp_connection.sendmail(smtp_username, recipient_emails, message.as_string())

# 断开与SMTP服务器的连接
smtp_connection.quit()