利用python实现outlook自动发邮件

import random
import pandas as pd
import numpy as np
# 在项目中注册模块才能使用client
import win32com.client as win32
import pywintypes
from datetime import datetime
import openpyxl
import time
from tqdm import tqdm


# 读取名单
class Mails():
    def __int__(self):
        self.a = ''

    def get_send_info(self,To_name,number,money):
        text = 
        f'''
        '''
        return text

    def send_email(self,to_email,cc_email,To_name,number,money):
        outlook = win32.Dispatch('outlook.application')
        mail = outlook.CreateItem(0)
        mail.To = to_email
        mail.CC = cc_email
        # 邮件主题
        mail.Subject = f'关于{datetime.now().year}年{datetime.now().month}月
        # 表示使用html发送邮件
        mail.BodyFormat = 2
        mail.HTMLBody = self.get_send_info(To_name,number,money)
        mail.Send()

    def run(self):
        info = pd.read_excel('send_email_.xlsx')
        with open('logging.txt','w',encoding='utf-8-sig') as f:
            # 进度条
            pbar = tqdm(range(len(info)))
            for i in pbar:
                pbar.set_description("Processing %s" % i)
                try:
                   To_name, number, money, to_email, cc_email = info.iloc[i][0], info.iloc[i][3], info.iloc[i][4],\
                                                             info.iloc[i][1], info.iloc[i][2]
                   self.send_email(to_email, cc_email, To_name, number, money)
                    # print(f'{To_name}-发送成功')
                   f.write(f'{To_name}-发送成功')
                   f.write('\n')
                except Exception as e:
                    # print(f'{To_name}-发送失败')
                    f.write(f'{To_name}-发送失败')
                    f.write('\n')
                finally:
                    time.sleep(random.randint(1, 3))

if __name__ == '__main__':
    mail = Mails()
    mail.run()