#!/usr/bin/env python # -*- coding: utf-8 -*-
from html import HTML from email.mime.text import MIMEText import mysql.connector import smtplib from email.mime.text import MIMEText from email.header import Header from email.mime.multipart import MIMEMultipart import traceback from html import HTML import pdb
#设置css样式 inline_css={ 'black':'color:#000000;', 'red':'color:#FF0000;', 'green':'color:#00FF00;', }
b = HTML()
b1=b.br("这是表格1:")
t1 = b.table(border='1',caption='table 1',width='800') with open('market_monitor_1.csv') as f: lines =f.readlines() for line in lines: datas = line.split('\t') r1=t1.tr() r1.td(datas[0] ,style=inline_css['black']) r1.td(datas[1] ,style=inline_css['black']) r1.td(datas[2] ,style=inline_css['black']) r1.td(datas[3] ,style=inline_css['black']) r1.td(datas[4] ,style=inline_css['black']) r1.td(datas[5] ,style=inline_css['black']) r1.td(datas[6] ,style=inline_css['black']) r1.td(datas[7] ,style=inline_css['black']) r1.td(datas[8] ,style=inline_css['black']) r1.td(datas[9] ,style=inline_css['black']) r1.td(datas[10],style=inline_css['black']) r1.td(datas[11],style=inline_css['black'])
b2=b.br("这是表格2:") t2 = b.table(border='1',width='600') with open('market_monitor_2.csv') as f: lines =f.readlines() for line in lines: datas = line.split('\t') r2=t2.tr() r2.td(datas[0] ,style=inline_css['black']) r2.td(datas[1] ,style=inline_css['black']) r2.td(datas[2] ,style=inline_css['black']) r2.td(datas[3] ,style=inline_css['black']) r2.td(datas[4] ,style=inline_css['black']) r2.td(datas[5] ,style=inline_css['black'])
b3=b.br("各渠道当日累计转化数据详见附件:market_monitor_channel.xls")
#print(b)
#发件人、发件邮箱服务器、收件人 mail_host="smtp.email.qq.com" #设置服务器 mail_user="123456@qq.com" #用户名 mail_pass="123456" #口令
sender = '123456@qq.com' receivers = ['123456@qq.com']
#邮件标题、发件人名称等 message = MIMEMultipart() message['From'] = Header("发件人名称", 'utf-8') message['To'] = Header(','.join(receivers), 'utf-8') subject = '邮件标题' message['Subject'] = Header(subject, 'utf-8')
#邮件正文内容为HTML message.attach(MIMEText(str(b), 'html', 'utf-8'))
# 构造附件,传送当前目录下的 market_monitor_channel.xls 文件 att1 = MIMEText(open('market_monitor_channel.xls', 'rb').read(), 'base64', 'utf-8') att1["Content-Type"] = 'application/octet-stream' att1["Content-Disposition"] = 'attachment; filename="market_monitor_channel.xls"' message.attach(att1)
try: smtpObj = smtplib.SMTP() smtpObj.connect(mail_host, 25) # 25 为 SMTP 端口号 smtpObj.login(mail_user,mail_pass) smtpObj.sendmail(sender, receivers, message.as_string()) print "邮件发送成功" except smtplib.SMTPException: print "Error: 无法发送邮件" |
|