1 编程语言 python 3.5
2 需要安装xlrd库,用来打开Excel文件
3 在命令行中输入 python send.py [接收者邮件地址] 如:python send.py 12345678@
4 发送邮件地址默认是作者的邮箱地址
# -*- coding: utf-8 -*-from email.mime.text import MIMETextfrom email.header import Headerfrom smtplib import SMTP_SSLimport xlrdimport sysdef send_mail(receiver):host_server = ''#QQ邮箱的SMTP服务器sender_qq = '1*******'#发件人的QQ号码pwd = '********'#QQ邮箱的授权码sender_qq_mail = '*****'#发件人邮箱地址data=xlrd.open_workbook('filename.xlsx')#打开文件table=data.sheets()[0]content=[]content=table.row_values(0)mail_content=content[0]+' '+content[1]+' '+content[2]+content[3]#邮件正文内容mail_title = ' '#设置邮件标题smtp = SMTP_SSL(host_server)#SSL 登录smtp.set_debuglevel(0)#set_debuglevel()是用来调试的。参数值为1表示开启调试模式,参数值为0关闭调试模式smtp.ehlo(host_server)#连接服务器smtp.login(sender_qq, pwd)#邮箱登录msg = MIMEText(mail_content, "plain", 'utf-8')#填写正文内容msg["Subject"] = Header(mail_title, 'utf-8')#填写邮件标题msg["From"] = sender_qq_mail#发送者邮箱地址msg["To"] = receiver#接收者邮件地址try:smtp.sendmail(sender_qq_mail, receiver, msg.as_string())#发送邮件函数smtp.quit()#发送邮件结束print("Successfully Send!")#输出成功标志except:print("The sever is busy,please continue later.")if __name__=="__main__":'''命令行输入标准格式为 python send.py [接收者邮件地址],如不添加邮件地址,则默认为*******@'''try:receiver=sys.argv[1]except:receiver = '********@'#收件人邮箱地址send_mail(receiver)#调用函数,发送邮件