【python】发送表格邮件

最新推荐文章于 2024-07-30 09:39:32 发布

原创最新推荐文章于 2024-07-30 09:39:32 发布 · 3.9k 阅读

8 ·

CC 4.0 BY-SA版权

python 专栏收录该内容

8 篇文章

订阅专栏

本文介绍了一种使用Python进行邮件自动化的方法，包括如何从CSV文件读取数据并将其转换为HTML格式的表格，以及如何将这些表格和附件通过邮件发送出去。此过程涉及到Python的多个库，如html, email.mime.text, mysql.connector, smtplib等，适用于自动化发送市场监控报告等场景。

#!/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: 无法发送邮件"