最近由于工作需要洞难，經(jīng)常要從一張匯總表中篩選出各組的數(shù)據(jù)票彪，然后分別點(diǎn)對(duì)點(diǎn)發(fā)送至各業(yè)務(wù)方。粘貼復(fù)制耗時(shí)又心累外莲，遇上有背景格式的還能轉(zhuǎn)半天圈圈猪半，哭唧唧o(╥﹏╥)o。因此嘗試python連接郵箱后偷线，從本地讀取excel文件后自動(dòng)發(fā)送磨确。需要用到的包有smtplib、email
一声邦、主要步驟
分三塊俐填，郵件主體；郵箱登陸翔忽；收件人英融、抄送人發(fā)送郵件。
#載入需要的包
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
1歇式、郵件主體
包含郵件正文 + excel附件
def main_email(text,xlsx_path,xlsx_name):
'''
*text->str: 要發(fā)送的郵件正文*
*xlsx_path: excel文件所在的路徑*
*xlsx_name：excel文件驶悟，例如a.xlsx*
'''
msg = MIMEMultipart()
#添加純文本，text為需要輸入的文本材失，字符串格式
text_msg = MIMEText(text)
msg.attach(text_msg)
def add_excel(xlsx_file,xlsx_name):#添加excel附件
# 將xlsx文件作為內(nèi)容發(fā)送到對(duì)方的郵箱讀取excel痕鳍，rb形式讀取，對(duì)于MIMEText()來(lái)說(shuō)默認(rèn)的編碼形式是base64 對(duì)于二進(jìn)制文件來(lái)說(shuō)沒(méi)有設(shè)置base64龙巨，會(huì)出現(xiàn)亂碼
msg_xlsx = MIMEText(open(xlsx_file, 'rb').read(), 'base64', 'utf-8')
# 設(shè)置文件在附件當(dāng)中的名字
msg_xlsx.add_header('Content-Disposition', 'attachment', filename=xlsx_name)
return msg_xlsx
msg_xlsx = add_excel(path + xlsx_name, xlsx_name)
msg.attach(msg_xlsx)
return msg
2笼呆、登陸郵箱
def login_email(smtpsever, username, pwd):
'''
*smtpsever: 郵箱服務(wù)器*
*username: 郵箱地址*
*pwd: 郵箱登陸密碼*
'''
#連接郵箱服務(wù)器
sever = smtplib.SMTP(smtpsever)
#登陸郵箱
result = sever.login(username, pwd)
print('登陸結(jié)果：', result)
return sever
3、發(fā)送郵件
def send_email(title, sender, to_receiver, cc_receiver, sever, msg):
'''
Subject郵件主體旨别，對(duì)應(yīng)要發(fā)送的郵件名诗赌，對(duì)應(yīng)值title為字符串
From發(fā)件人地址，對(duì)應(yīng)值sender為發(fā)送人郵箱地址
To收件人郵箱地址秸弛，Cc抄送人郵箱地址
to_receiver-> list
cc_receiver-> list铭若，可批量發(fā)送
sever: 第2步函數(shù)返回sever
msg: 第1步函數(shù)返回郵件主體
'''
msg['Subject'] = title
msg['From'] = sender
msg['To'] = ';'.join(to_receiver)
msg['Cc'] = ';'.join(cc_receiver)
receiver = ';'.join(to_receiver + cc_receiver)
sever.sendmail(sender, receiver.split(;), msg.as_string())
print('收件人', receiver)
參考
添加各類型附件： https://blog.csdn.net/handsomekang/article/details/9811355
代碼解釋：https://cloud.tencent.com/developer/article/1353552
主送、抄送递览、暗送：https://blog.csdn.net/nameofcsdn/article/details/76259998
