python通过读取excel邮件目录群发邮件练习

简单拼凑的，选择发送文件所在文件夹，选择发送文件名与邮箱对应目录，校验所含文件是否存在，批量给对应邮箱发送邮件。

import sys
from PyQt5 import QtWidgets, QtCore, QtGui
from PyQt5.QtWidgets import *
import os
import re
import time
import pygame
import xlrd
import smtplib                                  #发送邮件模块
from email.mime.text import MIMEText            #定义邮件内容
from email.mime.multipart import MIMEMultipart  #用于传送附件

pygame.mixer.init()

class picture(QWidget):
    def __init__(self):
        super(picture, self).__init__()
        self.path = []
        self.i = 0
        self.zct_k =800
        self.zct_g =600
        #主体窗口的宽度高度
        self.resize(self.zct_k, self.zct_g)
        #主体窗口标题
        self.setWindowTitle("邮件群发")
        label_bj = 'border-width:2px;border-style:solid;font-size:15px;' \
                   'border-color:rgb(255,170,0);background-color:rgb(100,149,237);'
        label_kd = 30
        label_gd = 20
        label_kkd = 73
        label_kgd = 22

        self.label3 = QLabel(self)
        self.label3.setText("标题信息")
        self.label3.move(label_kd, label_gd)
        self.label3.setFixedSize(label_kkd, label_kgd)
        self.label3.setStyleSheet(label_bj)

        self.label4 = QLabel(self)
        self.label4.setText("邮件正文")
        self.label4.move(label_kd, label_gd+30)
        self.label4.setFixedSize(label_kkd, label_kgd+70)
        self.label4.setStyleSheet(label_bj)

        self.lineEdit3 = QLineEdit(self)
        self.lineEdit3.setText("标题")
        self.lineEdit3.move(label_kd + 90, label_gd )
        self.lineEdit3.setFixedSize(label_kkd+575, label_kgd )
        self.lineEdit3.setStyleSheet(label_bj)

        self.lineEdit5 = QTextEdit(self)
        self.lineEdit5.setText("正文")
        self.lineEdit5.move(label_kd+ 90, label_gd + 30 )
        self.lineEdit5.setFixedSize(label_kkd+575, label_kgd+70 )
        self.lineEdit5.setStyleSheet(label_bj)

        self.label2 = QLabel(self)
        self.label2.setText("显示文件所在路径")
        self.label2.move(120, 90+60)
        self.label2.setFixedSize(650, 22)
        self.label2.setStyleSheet(label_bj)

        #打开图片_按钮
        btn = QPushButton(self)
        btn.setText("选择文件夹")
        #打开图片 按钮 显示位置
        btn.move(30, 90+60)
        btn.clicked.connect(self.openimage)

        self.label5 = QLabel(self)
        self.label5.setText("显示文件")
        self.label5.move(120, 120+60)
        self.label5.setFixedSize(650, 22)
        self.label5.setStyleSheet(label_bj)

        # 打开图片_按钮
        btn_bf = QPushButton(self)
        btn_bf.setText("邮箱_目录")
        # 打开图片 按钮 显示位置
        btn_bf.move(30, 120+60)
        btn_bf.clicked.connect(self.ope_bf)

        # 打开图片_按钮
        btn_yj= QPushButton(self)
        btn_yj.setText("发送_邮件")
        # 打开图片 按钮 显示位置
        btn_yj.move(30, 150+60)
        btn_yj.setFixedSize(label_kkd , label_kgd + 100)
        btn_yj.clicked.connect(self.yjfs)

        self.label6 = QLabel(self)
        self.label6.setText("操作反馈")
        self.label6.move(label_kd+90, label_gd+190)
        self.label6.setFixedSize(label_kkd+577, label_kgd+100)
        self.label6.setStyleSheet(label_bj)


    def openimage(self):
        """图片打开窗体"""
        #记录打开文件夹信息
        imgName_bc = QFileDialog.getExistingDirectory(self, "选择文件夹", "")
        # 在页面显示打开的图片路径
        self.label2.setText(imgName_bc)
        #打开文件路径 并被拉伸到窗体显示大小
        list = get_filelist(imgName_bc, [])
        for e in list:
            result = eval(repr(e).replace('\\\\', '/'))
            ret = re.match(r".*docx", result)
            if ret:
                #将文件导入
                self.path.append(ret.group())

            else:
                pass
        #print(len(self.path))

    def ope_bf(self):
        """图片打开窗体"""
        #"*.jpg;;*.png;;All Files(*)" 是在打开窗体下显示的类型
        imgName, imgType = QFileDialog.getOpenFileName(self, "打开文件", "", "*.xls;;All Files(*)")
        #打开文件路径 并被拉伸到窗体显示大小
        self.label5.setText(imgName)

        data = xlrd.open_workbook(imgName)
        # 通过表名限制
        table3 = data.sheet_by_name('Sheet1')
        # 共有多少行数据
        nrows = table3.nrows
        self.shuzu = {}
        i = 0
        while i < nrows:
            itema = table3.row_values(i)
            itema_zd = {itema[0]:itema[1]}
            self.shuzu.update(itema_zd)

            i += 1
        #print(self.shuzu)

    def yjfs(self):
        """图片打开窗体"""
        for i in self.path:
            wjm = re.match(r".*/(.*)\.docx$", i)
            wjm_qm = re.match(r".*/(.*\.docx)$", i)
            print(wjm_qm.group(1))

            for t in self.shuzu:
                if t == wjm.group(1):
                    print(self.shuzu[t],i)

                    # 发送邮箱服务器
                    smtpserver = 'smtp.163.com'
                    # 发送邮箱用户名密码
                    user = 'xxxxx@163.com'
                    password = 'xxxxxx'
                    # 发送和接收邮箱
                    sender = 'xxxxx@163.com'
                    receives = [self.shuzu[t]]
                    print(self.shuzu[t])
                    print('----------><----------------')
                    # 发送邮件主题和内容
                    subject = self.lineEdit3.text()
                    print(subject)
                    print('----------><----------------')
                    content = self.lineEdit5.toPlainText()
                    print(content)
                    print('----------><----------------')
                    # 构造附件内容：定义附件，构造附件内容
                    send_file = open(i,'rb').read()  # 'rb'表示r读取，b表示二进制方式读取
                    print(i)

                    att = MIMEText(send_file, 'base64', 'utf-8')  # 调用传送附件模块，传送附件

                    att["Content-Type"] = 'application/octet-stream'

                    att["Content-Disposition"] = 'attachment;filename="区县.docx"' # 附件描述外层要用单引号
                    # 构建发送与接收信息
                    msgRoot = MIMEMultipart()  # 发送附件的方法定义为一个变量
                    msgRoot.attach(MIMEText(content, 'html', 'utf-8'))  # 发送附件的方法中嵌套发送正文的方法
                    msgRoot['subject'] = subject
                    msgRoot['From'] = sender
                    msgRoot['To'] = ','.join(receives)
                    msgRoot.attach(att)  # 添加附件到正文中
                    # SSL协议端口号要使用465
                    smtp = smtplib.SMTP_SSL(smtpserver, 465)
                    # HELO 向服务器标识用户身份
                    smtp.helo(smtpserver)
                    # 服务器返回结果确认
                    smtp.ehlo(smtpserver)
                    # 登录邮箱服务器用户名和密码
                    smtp.login(user, password)
                    print("Start send email...")
                    smtp.sendmail(sender, receives, msgRoot.as_string())
                    smtp.quit()
                    print("Send End！")

                else:
                    pass


def get_filelist(dir , Filelist):
    """导入文件夹，读取内容"""

    newDir = dir
    if os.path.isfile(dir):
        Filelist.append(dir)
    elif os.path.isdir(dir):
        for s in os.listdir(dir):
            newDir = os.path.join(dir,s)

            get_filelist(newDir,Filelist)
        pass
    return Filelist

if __name__ == "__main__":
    app = QtWidgets.QApplication(sys.argv)
    #窗体显示
    my = picture()
    my.show()

    sys.exit(app.exec_())