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('邮件发送成功!')



