每日定时发送邮件，邮件中包含excel数据
发送邮件代码# -*- Coding:utf-8 -*-import email, smtplib, sslfrom email import encodersfrom email.mime.base import MIMEBasefrom email.mime.multipart import MIMEMultipartfrom email.mime.text import MIMETextimport timesmtp_server = "smtp.exmail.qq.com"sender_email = "[email protected]" # Enter your addresspassword = "1234"port = 25receiver_email = ["[email protected]"] # Enter receiver addresssubject = "测试邮件主题"body = """测试邮件内容"""# 发送方法，file_name是发送附件的路径与名称def send_email(file_name): # Create a multipart message and set @R_419_5548@s message = MIMEMultipart() message["From"] = sender_email # mime message must be strings message["To"] = ', '.join(receiver_email) subjectTxt = subject.format(time.strftime('%Y%m%d%H%M',time.localtime(time.time()))) message["Subject"] = subjectTxt # mime message must be strings message["Bcc"] = ', '.join(receiver_email) # Recommended for mass emails # Add body to email message.attach(MIMEText(body.format(subjectTxt), "plain")) # Open pdf file in binary mode with open(file_name, "rb") as attachment: # Add file as application/octet-stream # Email clIEnt can usually download this automatically as attachment part = MIMEBase("application", "octet-stream") part.set_payload(attachment.read()) # Encode file in ASCII characters to send by email encoders.encode_base64(part) # Add @R_419_5548@ as key/value pair to attachment part part.add_@R_419_5548@( "Content-disposition", f"attachment; filename= {file_name}", ) # Add attachment to message and convert message to string message.attach(part) text = message.as_string() # Log in to server using secure context and send email context = ssl.create_default_context() with smtplib.SMTP(smtp_server, port) as server: server.ehlo() # Can be omitted server.starttls(context=context) server.ehlo() # Can be omitted server.login(sender_email, password) server.sendmail(sender_email, receiver_email, text)@H_301_13@这里是关键的发邮件代码，执行send_email方法，相对路径+文件名称作为参数，即可发送邮件。本地测试成功后即可部署到服务器
部署到阿里云服务器前置准备：请自行安装python3
本地测试成功，部署到阿里云服务器，出现异常：
file "/data/scripts/cps-email/SendEmail.py", line 64, in send_email with smtplib.SMTP(smtp_server, port) as server: file "/usr/local/python-3.6.7/lib/python3.6/smtplib.py", line 251, in __init__ (code, msg) = self.connect(host, port) file "/usr/local/python-3.6.7/lib/python3.6/smtplib.py", line 338, in connect (code, msg) = self.getreply() file "/usr/local/python-3.6.7/lib/python3.6/smtplib.py", line 394, in getreply raise SMTPServerdisconnected("Connection unexpectedly closed")smtplib.SMTPServerdisconnected: Connection unexpectedly closed@H_301_13@异常原因：
代码中使用发送邮件服务的端口是25，在阿里云上是不安全端口
解决方法：
端口换成：456修改代码原代码：
# Log in to server using secure context and send email context = ssl.create_default_context() with smtplib.SMTP(smtp_server, port) as server: server.ehlo() # Can be omitted server.starttls(context=context) server.ehlo() # Can be omitted server.login(sender_email, password) server.sendmail(sender_email, receiver_email, text)@H_301_13@改成如下：
# Log in to server using secure context and send email context = ssl.create_default_context() with smtplib.SMTP_SSL(smtp_server, port) as server: server.login(sender_email, password) server.sendmail(sender_email, receiver_email, text)@H_301_13@再次执行脚本成功发送
使用crontab定时执行Python脚本如果是直接在crontab中执行python脚本：
*/1 * * * * python3 /data/scripts/cps-email/Report.py /data/scripts/cps-email/run.log 2>&1@H_301_13@会出现脚本中文件路径错误问题，必须使用绝对路径。因为crontab执行脚本时根目录是python3的安装路径
解决办法是把执行语句放入shell脚本中执行：
#发送cps邮件数据#!/bin/bash#切换到脚本目录cd /data/scripts/cps-email/python3 /data/scripts/cps-email/Report.py@H_301_13@再把shell脚本部署到crontab中：
*/1 * * * * sh /data/scripts/cps-email/sendcpsEmail.sh >> /data/scripts/cps-email/run.log 2>&1@H_301_13@测试成功，大功告成！
总结以上是内存溢出为你收集整理的使用Python定时发送邮件全部内容，希望文章能够帮你解决使用Python定时发送邮件所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。
欢迎分享，转载请注明来源：内存溢出
微信扫一扫
支付宝扫一扫
评论列表（0条）