python读取excel群发邮件（二）

最新推荐文章于 2022-12-18 22:55:58 发布

原创最新推荐文章于 2022-12-18 22:55:58 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

Python学习专栏收录该内容

328 篇文章

订阅专栏

本文介绍了一个使用Python实现的自动化脚本，用于通过SMTP协议发送文本邮件。脚本包括邮件登录、构建邮件内容、发送邮件等功能，适用于自动化任务中邮件通知的需求。

#!/usr/local/bin/python2.7
# encoding: gbk

import smtplib
import email
import os
import traceback
from email.message import Message
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.image import MIMEImage
from email.mime.base import MIMEBase
from email import encoders
import mimetypes
from email.mime.audio import MIMEAudio
import xlrd
import pykka
import sys
reload(sys)
sys.setdefaultencoding('gbk')

smtpserver='smtp.xxx.com'
smtpuser='wuxiaobing@xxx.com'
smtppass='xxxx'
smtpport='25'

def login():
    server=smtplib.SMTP(smtpserver,smtpport)
    server.ehlo()
    server.login(smtpuser,smtppass)
    return server

def sendTextEmail(toAdd,subject,content):

    result = False
    server = login()
    msg = Message()
    msg['Mime-Version']='1.0'
    msg['From']    = smtpuser
    msg['To']      = toAdd
    msg['Subject'] = subject
    msg['Date']    = email.Utils.formatdate()          # curr datetime, rfc2822
    msg.set_payload(content)
    try:
        server.sendmail(smtpuser,toAdd,str(msg))   # may also raise exc
        result = '发送收件人： '+toAdd+'成功 ! '
    except Exception:
        #print Exception,ex
        print '发送收件人： '+toAdd+' 失败!'

    return result

#if __name__ == '__main__':