Python利用smtp批量获取excel用户信息并发送邮件

from openpyxl import load_workbook

import smtplib  # 加载smtplib模块
from email.mime.text import MIMEText
from email.utils import formataddr
wb=load_workbook("账号.xlsx")
# print(wb.sheetnames)
sheet=wb["学习卡"] #wb.active
user=[]

for row in sheet.iter_rows(min_row=2,):
    user.append(row[3].value)

my_sender = '*****@qq.com'  # 发件人邮箱账号，为了后面易于维护，所以写成了变量
my_user=",".join(user)# 收件人邮箱账号，为了后面易于维护，所以写成了变量，可以列表形式，这里将列表改成字符串
my_psd ="dsbgxtqycjjbcacc" #邮箱密码，qq邮箱为开启smtp服务后的序列号
for row in sheet.iter_rows(max_row=1,):#获取excel表头
    title = "<thead>"
    for cell in row:
        # print(cell.value,end=",")
        title+= f"<th>{cell.value}</th>"
    title+="</thead>"

def mail():
    ret = True
    try:
        msg_txt = f'''
            <p&