import smtplib import pandas as pd from email.mime.text import MIMEText user = '******@qq.com'#发件人qq邮箱 code = '**********eg' data = pd.read_excel('客户资料统计3.xls', sheet_name=0)#收件人 e_mail = data['邮箱'].tolist() to = ','.join(e_mail) message = MIMEText('邮件内容') message['Subject'] = '邮件主题' message['From'] = user message['To'] = to server = smtplib.SMTP_SSL('smtp.qq.com', 465)#qq邮箱端口 server.login(user, code) server.send_message(message) server.quit() print('邮件发送成功!')