匹配两个文件中的数据，然后通过电子邮件发送给每个人

import csv

def read_csv(file_path):
    with open(file_path, mode='r', encoding='utf-8') as file:
        reader = csv.DictReader(file)
        return list(reader)

def match_data(file1_data, file2_data, key):
    matched_data = []
    for item1 in file1_data:
        for item2 in file2_data:
            if item1[key] == item2[key]:
                matched_data.append({**item1, **item2})
                break
    return matched_data

# 示例数据
file1_data = read_csv('file1.csv')
file2_data = read_csv('file2.csv')

matched_data = match_data(file1_data, file2_data, 'ID')

import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart

def send_email(to_email, subject, body):
    from_email = 'your_email@example.com'
    password = 'your_email_password'

    msg = MIMEMultipart()
    msg['From'] = from_email
    msg['To'] = to_email
    msg['Subject'] = subject

    msg.attach(MIMEText(body, 'plain'))

    server = smtplib.SMTP('smtp.example.com', 587)
    server.starttls()
    server.login(from_email, password)
    text = msg.as_string()
    server.sendmail(from_email, to_email, text)
    server.quit()

# 示例发送邮件
for data in matched_data:
    to_email = data['email']
    subject = 'Matched Data'
    body = f"Your matched data is: {data}"
    send_email(to_email, subject, body)