Python自动化办公实战案例：文件整理与邮件发送

import os  
import shutil  
  
def sort_files(input_folder, output_base_folder):  
    # 遍历input_folder文件夹中的所有文件  
    for filename in os.listdir(input_folder):  
        file_path = os.path.join(input_folder, filename)  
          
        # 判断文件是否为普通文件  
        if os.path.isfile(file_path):  
            # 获取文件扩展名  
            extension = os.path.splitext(filename)[1][1:].lower()  
              
            # 定义文件目标文件夹  
            output_folder = os.path.join(output_base_folder, extension)  
              
            # 如果目标文件夹不存在，则创建  
            if not os.path.exists(output_folder):  
                os.makedirs(output_folder)  
              
            # 将文件移动到目标文件夹  
            shutil.move(file_path, os.path.join(output_folder, filename))  
  
# 使用示例  
input_folder = 'path/to/input_folder'  # 替换为实际的输入文件夹路径  
output_base_folder = 'path/to/output_base_folder'  # 替换为实际的输出文件夹路径  
sort_files(input_folder, output_base_folder)

import csv  
import smtplib  
from email.mime.multipart import MIMEMultipart  
from email.mime.text import MIMEText  
from email.mime.base import MIMEBase  
from email import encoders  
  
def send_email(sender, password, recipients, subject, body, attachment_path):  
    # 创建邮件对象  
    msg = MIMEMultipart()  
      
    # 设置邮件信息  
    msg['From'] = sender  
    msg['To'] = ', '.join(recipients)  
    msg['Subject'] = subject  
      
    # 设置邮件正文  
    msg.attach(MIMEText(body, 'plain'))  
      
    # 添加附件  
    with open(attachment_path, 'rb') as attachment:  
        part = MIMEBase('application', 'octet-stream')  
        part.set_payload(attachment.read())  
        encoders.encode_base64(part)  
        part.add_header('Content-Disposition', "attachment; filename= " + os.path.basename(attachment_path))  
        msg.attach(part)  
      
    # 连接邮件服务器并发送邮件  
    with smtplib.SMTP('smtp.example.com', 5587) as server:
          server.starttls()
          server.login(sender, password)
          server.sendmail(sender, recipients, msg.as_string())
def send_emails_from_csv(csv_file_path, sender, password):
       with open(csv_file_path, 'r', encoding='utf-8') as csvfile:
            reader = csv.DictReader(csvfile)
       for row in reader:
            recipient = row['Email']
            attachment_path = row['FilePath']
            subject = "File Attachment"
            body = "Please find the attached file."
            send_email(sender, password, [recipient], subject, body, attachment_path)
 
#使用示例
csv_file_path = 'path/to/emails.csv' # 替换为实际的CSV文件路径
sender = 'your-email@example.com' # 替换为发件人邮箱
password = 'your-email-password' # 替换为发件人邮箱密码
send_emails_from_csv(csv_file_path, sender, password)