小白求教大神:
我想把对excel的操作输出直接发送给我的邮箱。网上找了段发送邮件代码可以成功发送邮件。但是想请教下这些命令的输出(包含3个df类型数据以及3个饼图),发送这样的数据我应该怎么修改发送的内容这一行message = MIMEText(comment_df, "plain", "utf-8")
import smtplib
from email.mime.text import MIMEText
from email.header import Header
import pandas as pd
comment_df = pd.read_excel(r"C:\Users\lih21\Desktop\python\task 3.1\comment_nm.xlsx")
comment_df
mail_host = "smtp.qq.com"
mail_user = "326263013@qq.com"
auth = "fyxdixumqvbqbhjh" # 这个是自己qq邮箱的授权码
sender = "32626301@qq.com"
receivers = ["XXX@dell.com"]
message = MIMEText(comment_df, "plain", "utf-8")
message['from'] = Header("32626301@qq.com", "utf-8")
message['to'] = Header("XXX@dell.com", "utf-8")
subject = "this is the subject"
message['subject'] = Header(subject, "utf-8")
try:
smtpObj = smtplib.SMTP_SSL('smtp.qq.com') # 建立smtp连接,qq邮箱必须用ssl边接,因此边接465端口
smtpObj.connect(host = "smtp.qq.com", port = 465)
smtpObj.login(mail_user, auth) # 登陆
smtpObj.sendmail(sender, receivers, message.as_string()) # 发送
print("succeed sending")
smtpObj.quit()
except smtplib.SMTPException as err:
print("can not send the email")