我有以下代码,它使用python应用程序发送SQL命令的输出。在command = 'osql -E -S sqlconn -d database -Q "set nocount on;select t, COUNT(*) "Count" from risk group by t "
output = subprocess.check_output(command)
message = """From:XYZ
To: To ABC
Subject: Report for run
"""
message = message + str(output)
try:
smtpObj = smtplib.SMTP('smtpserver',25)
smtpObj.sendmail(sender,receivers,message)
except SMTPException:
print ('Error in sending email')
但是,问题是电子邮件包含的邮件格式不正确,\r\n。在
什么是更好的格式和发送电子邮件的方法。在
收到的电子邮件示例:b' t Count \r\n -----------------------
----------- \r\n 2013-06-04 00:00:00.000 6605 \r\n\r\n'