import pandas as pd
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
filename='C:\\Users\\thinkpad\\Desktop\\1.xlsx' #附件地址
def send_mail(to_list,sub,context,filename): #to_list:收件人;sub:主题;content:邮件内容
mail_host="smtp.163.com" #设置服务器
mail_user="XXXX@163.com" #用户名
mail_pass="xxxxxx" #口令
mail_postfix="163.com" #发件箱的后缀
me="服务器"+"<"+mail_user+"@"+mail_postfix+">" #这里的“服务器”可以任意设置,收到信后,将按照设置显示
msg = MIMEMultipart() #给定msg类型
msg['Subject'] = sub #邮件主题
msg['From&#