要解决一个定时发送报表给特定人员的问题,利用crontab + Python smtplib很方便就解决了,邮件发送代码如下
#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""
Author: wukai15937@gmail.com
Datetime: 2018/7/16 下午5:09
"""
from __future__ import unicode_literals, print_function, division, absolute_import
import smtplib
import datetime
import pytz
import time
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.header import Header
from email.utils import formataddr
from email.mime.application import MIMEApplication
# 你的邮箱所使用的邮件服务器
mail_host = "smtp.163.com"
# 你的邮箱
mail_user = "wukai_work@163.com"
# 你的邮箱密码
mail_pass = "******"
# 接收邮箱列表
recv = ['1614617460@qq.com']
# m = MIMENonMultipart('hello, 文博', 'plain', 'utf-8')
m = MIMEMultipart()
m['From'] = formataddr(["wukai", mail_user])
m['to'] = formataddr(["wenbo", recv])
pytz_ = datetime.datetime.fromtimestamp(int(time.time()) - 86400, pytz.timezone('Asia/Shanghai')).strftime('%Y-%m-%d %H:%M:%S')
#标题
subject = '%s 智能琴激活' % (pytz_.split(' ')[0])
m['Subject'] = Header(subject, 'utf-8')
# 文字描述内容
m.attach(MIMEText('这是昨日智能琴激活的文件', 'plain', 'utf-8'))
# 添加xls文件
att1 = MIMEApplication(open('hello.xls', 'rb').read())
att1["Content-Type"] = 'application/octet-stream'
# 这里的filename可以任意写,写什么名字,邮件中显示什么名字
# att1["Content-Disposition"] = 'attachment; filename="每日未购买.xlsx"'
att1.add_header('Content-Disposition', 'attachment', filename=('utf8', '', '%s-%s-%s 激活.xlsx'.encode('utf-8') % (str(datetime.date.today().year), datetime.date.today().month, datetime.date.today().day)))
m.attach(att1)
smtpObj = smtplib.SMTP()
smtpObj.connect(mail_host, 25)
smtpObj.login(mail_user, mail_pass)
smtpObj.sendmail('wukai_work@163.com', recv, m.as_string())