自动化办公--协助财务自动发送工资条

#!/usr/bin/python
# -*- coding: UTF-8 -*-

import smtplib
from email.mime.text import MIMEText
from email.header import Header
from xpinyin import Pinyin
import datetime as dt
import pandas as pd
import xlrd
import os

def loginmail(name,content):
    p = Pinyin()
    # 第三方 SMTP 服务
    mail_host = "smtp.163.com"  # 设置服务器
    mail_user = "zhangMingMingmj@163.com"  # 用户名
    mail_pass = "VYCSWZBGIWMQVNGG"  # 口令
    port = 465
    sender=mail_user    #用户名
    receivers =p.get_pinyin(name, ‘‘)+‘@qq.com‘
    body = content 
    # 设置邮件正文，这里是支持HTML的
    msg = MIMEText(body, ‘html‘) 
    # 设置正文为符合邮件格式的HTML内容
    msg[‘subject‘] =  ‘{}年{}月份工资条‘.format(dt.datetime.now().year, dt.datetime.now().month-1) 
    # 设置邮件标题
    msg[‘from‘] = sender  
    # 设置发送人
    msg[‘to‘] = receivers  

    try:
        #ssl
        smtpObj = smtplib.SMTP_SSL(mail_host, port)
        smtpObj.login(mail_user, mail_pass)
        smtpObj.sendmail(sender, receivers, msg.as_string())
        print("邮件发送成功"+receivers)
    except smtplib.SMTPException:
        print("Error: 发送失败"+receivers)

def main():
    print("准备发送")
    excel_name = input("请输入需要执行的excel文件路径:")
    if os.path.isfile(excel_name):
        sheet=pd.read_excel(excel_name)
        for row in sheet.iloc:
            df=pd.DataFrame(row)
            loginmail(row["姓名"],df.to_html())
    else:
        print("找不到此目录下的"+excel_name)

    os.system(‘pause‘)

if __name__ == ‘__main__‘:
    main()