为了解放生产力(摸鱼),最近花时间完成了每日接报Excel表数据和Word文档的解析、报告的生成、QQ邮箱外发的自动化工作。由于在QQ邮箱外发时碰见中文乱码的问题,记录下解决方法(标有注释的部分自行修改就可以直接使用了)~
import smtplib
import email
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.header import Header
mail_host = 'smtp.qq.com'
#发件人
mail_sender = '4*****@qq.com'
#发件人授权码
mail_license = 'tq*****'
#收件人:对应修改,可以有多个
mail_receivers = ['1*****@qq.com']
mm = MIMEMultipart('related')
#发、收件人
mm['from'] = 'K***'%mail_sender
mm['to'] = 'Z***'%mail_receivers
#邮件主题
subject_content = '每日报告'
mm['subject'] = Header(subject_content,'utf-8')
#添加正文文本
body_content = 'Z**,每日报告部分请在附件中查收'
message_text = MIMEText(body_content,'plain','utf-8')
mm.attach(message_text)
#附件,解决乱码
attach_file = '测试报告.docx'
atta = MIMEText(open(attach_file, 'rb').read(), 'base64', 'utf-8')
atta['Content-Type'] = 'application/octet-stream'
atta.add_header('Content-Disposition', 'attachment', filename=('utf-8', '', attach_file))
mm.attach(atta)
stp = smtplib.SMTP()
# 设置发件人邮箱的域名和端口,QQ端口地址为465或587
stp.connect(mail_host, 587)
stp.set_debuglevel(1)
stp.login(mail_sender,mail_license)
stp.sendmail(mail_sender, mail_receivers, mm.as_string())
print("邮件发送成功")
stp.quit()
拉了个定时任务,每天自动完成并发送。再也不用晚上一边打游戏一边赶报告了,感觉又是美好的一天~