import smtplib
from email import (header)
from email.mime import (text, application, multipart)
from datetime import date, datetime
import time


def sender_mail():
 smt_p = smtplib.SMTP() # 创建对象
 smt_p.connect(host='smtp.qq.com', port=25) # 设置smtp服务器
 sender = '113097485@qq.com'
 password = "**********" # 在qq邮箱设置开启SMTP服务并复制授权码到password
 smt_p.login(sender, password) # 进行邮箱登录一次,填写你本人的邮箱
 receiver_addresses, count_num = [
 'guozhennianhua@163.com', 'xiaoxiazi99@163.com'], 1
 for email_address in receiver_addresses:
 # 表格中邮箱格式不正确,如有空字符,在发邮件的时候会出现异常报错,捕获到这些异常就跳过
 try:
 msg = multipart.MIMEMultipart()
 msg['From'] = "zhenguo" # 设置发邮件人
 msg['To'] = email_address # 收件人
 # msg['Cc'] = 'guozhennianhua@163.com'
 msg['subject'] = header.Header('通知', 'utf-8') # 主题名称
 msg.attach(text.MIMEText(
 '您好!\n这是一封测试邮件,使用Python实现自动发邮件,请勿回复本邮件功能~\n\n 祝您工作愉快!', 'plain', 'utf-8'))
 xlsxpart = application.MIMEApplication(
 open(r'./data/email_test.xlsx', 'rb').read())
 xlsxpart.add_header('Content-Disposition',
 'attachment', filename='1.xlsx')
 msg.attach(xlsxpart) # 添加邮件的附件
 smt_p.sendmail(sender, email_address, msg.as_string()) # 发送邮件
 time.sleep(10) # sleep10秒避免发送频率过快,可能被判定垃圾邮件。
 print('第%d次发送给%s' % (count_num, email_address))
 count_num = count_num + 1
 except Exception as e:
 print('第%d次给%s发送邮件异常' % (count_num, email_address))
 continue
 smt_p.quit()


sender_mail()