Python邮件发送（二）

最新推荐文章于 2023-07-28 14:44:27 发布

萝卜丝包治百病

最新推荐文章于 2023-07-28 14:44:27 发布

阅读量244

点赞数

文章标签：大数据

本文链接：https://blog.csdn.net/weixin_51502698/article/details/125777856

版权

import smtplib
import pandas as pd
from email.mime.text import MIMEText
from email.header import Header
from email.mime.application import MIMEApplication
from email.mime.multipart import MIMEMultipart


# 个性化html邮件发送
# 1.读取参会人信息
# 2.构建每个人参会人员的html
# 3.通过email构建邮件体
# 通过smtplib进行构建发送

# 构建html
def get_htm_context():
    html_context = """<!DOCTYPE html>
    <html lang="en">
    
    <head>
      <meta charset="UTF-8">
      <meta http-equiv="X-UA-Compatible" content="IE=edge">
      <meta name="viewport" content="width=device-width, initial-scale=1.0">
      <title>重置您的 无敌软件的 密码</title>
    
      <style>
        body,html,div,ul,li,button,p,img,h1,h2,h3,h4,h5,h6 {
          margin: 0;
          padding: 0;
        }
    
        body,html {
          background: #fff;
          line-height: 1.8;
        }
    
        h1,h2,h3,h4,h5,h6 {
          line-height: 1.8;
        }
    
        .email_warp {
          height: 100vh;
          min-height: 500px;
          font-size: 14px;
          color: #212121;
          display: flex;
          /* align-items: center; */
          justify-content: center;
        }
    
        .logo {
          margin: 3em auto;
          width: 200px;
          height: 60px;
        }
    
        h1.email-title {
          font-size: 26px;
          font-weight: 500;
          margin-bottom: 15px;
          color: #252525;
        }
    
        a.links_btn {
          border: 0;
          background: #4C84FF;
          color: #fff;
          width: 100%;
          height: 50px;
          line-height: 50px;
          font-size: 16px;
          margin: 40px auto;
          box-shadow: 0px 2px 4px 0px rgba(0, 0, 0, 0.15);
          border-radius: 4px;
          outline: none;
          cursor: pointer;
          transition: all 0.3s;
          text-align: center;
          display: block;
          text-decoration: none;
        }
    
        .warm_tips {
          color: #757575;
          background: #f7f7f7;
          padding: 20px;
        }
    
        .warm_tips .desc {
          margin-bottom: 20px;
        }
    
        .qr_warp {
          max-width: 140px;
          margin: 20px auto;
        }
    
        .qr_warp img {
          max-width: 100%;
          max-height: 100%;
        }
    
        .email-footer {
          margin-top: 2em;
        }
    
        #reset-password-email {
          max-width: 500px;
        }
        #reset-password-email .accout_email {
          color: #4C84FF;
          display: block;
          margin-bottom: 20px;
        }
      </style>
    </head>
    
    <body>
      <section class="email_warp">
        <div id="reset-password-email">
          <div class="logo">
            <img src="https://lf3-cdn-tos.bytescm.com/obj/static/xitu_juejin_web/dcec27cc6ece0eb5bb217e62e6bec104.svg" alt="logo">
          </div>
    
          <h1 class="email-title">
            尊敬的<span>AAA</span>您好：
          </h1>
          <p>您正在为登录邮箱为如下地址的 啦啦啦 账户重置密码：</p>
          <b class="accout_email">xxxx@abc.com</b>
    
          <p>请注意，如果这不是您本人的操作，请忽略并关闭此邮件。</p>
          <p>如您确认重置 XXXX 的账户密码，请点击下方按钮。</p>
    
          <a class="links_btn" onclick="window.open('https:XXXXXXXXXXX')">重置密码</a>
    
          <div class="warm_tips">
            <div class="desc">
              为安全起见，以上按钮为一次性链接，且仅在24小时内有效，请您尽快完成操作。
            </div>
    
            <p>如有任何疑问或无法完成注册，请通过如下方式与我们联系：</p>
            <p>邮箱：support@XXX.cn</p>
            <p>微信助理：XXXXX</p>
    
            <div class="qr_warp">
              <img src="https://XXXXXXXXXXXX" alt="微信二维码图片">
            </div>
            <p>本邮件由系统自动发送，请勿回复。</p>
          </div>
    
          <div class="email-footer">
            <p>您的智能项目助理</p>
            <p>XXXXXXXX</p>
          </div>
        </div>
      </section>
    </body>
    
    </html>
    
    
    """


if __name__ == '__main__':
    # 读取参会人员信息通过pandas
    info_df = pd.read_excel("infodata.xlsx")
    # print(info_df_list)

    # 2.构建每个参会人员的html
    # 以字典形式返回
    info_dict_list = info_df.to_dict(orient="records")  # 字典形式输出
    # print(info_dict_list)
    for info in info_dict_list:
        concurrent_html = get_htm_context(info["姓名"], info["住宿情况"])
        info["html"] = concurrent_html
    print(info_dict_list)

    # 3.email构建
    for info in info_dict_list:
        msg = MIMEMultipart()
        # 加上from 与 to
        msg["from"] = "wutengyuewutengyue@163.com"
        msg["to"] = info["邮箱"]

        # 设置标题
        msg["to"] = Header("BBMML分会", "utf-8")  # 邮件标题
        # 邮件内容
        htmlmsg = MIMEText(info["html"], "html", "utf-8")  # plain是表示纯文本，但是html
        msg.attach(htmlmsg)  # 添加附件

        # 添加pdf附件
        pdfpart = MIMEApplication(open("附件.pdf", "rb").read())  # 只读
        pdf.add_header("Content-Disposition", "attachment", filename="峰会日程")
        msg.attach(pdfpart)

        # 邮件附件图片
        imgpart = MIMEApplication(open("1.jpg", "rb").read())
        imgpart.add_header("Content-Disposition", "attachment", filename="BBML.png")
        msg.attach(imgpart)

        # 4,通过smtp进行发送
        smtp_obj = smtplib.SMTP("smtp.163.com", 25)
        # 发送邮件
        sender_email = "2819140738@qq.com"
        # sender授权码
        sender_pass = "SSHJJBYNRMFYEOTO"

        # 登录
        smtp_obj.login(sender_email, sender_pass)
        # 发送人、收件人、邮件信息
        smtp_obj.sendmail(sender_email, info["邮箱"], msg.as_string())
        print("发送完成")
        smtp_obj.quit()
    pass