'''
Created on 2024年7月25日
@author: 13990
'''
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.header import Header
from openpyxl.reader.excel import load_workbook
#读取信息
wb=load_workbook("J:/人力资源/23-年度薪酬沟通/2024年/批量发送邮件测试.xlsx")
sheet=wb.active
for row in sheet.iter_rows(min_row=2):
row_text=""
for cell in row:
# print(cell.value,end=",")
row_text+=f"{cell.value},"
acct_name=row[1] #收件人
acct_mail=row[0] #收件邮箱
file_addr=row[3] #附件地址
file_name=row[4] #附件文件名称
# print(f"{acct_mail.value}")
mail_host = "smtp.139.com"
mail_sender = "139XXXX6663@139.com" #按实际邮箱填写
mail_license = "xxxxxxxxxxxx1200" #按实际授权码填写
mail_receivers = [f"{acct_mail.value}"]
mm = MIMEMultipart('related')
subject_content = """2023年度薪酬福利报告"""
mm["From"] = "Custtomer<139XXXX6663@139.com>" #按实际邮箱填写
mm["To"] = f"{acct_name.value}<{acct_mail.value}>"
mm["Subject"] = Header(subject_content,'utf-8')
body_content = f'''
{acct_name.value},您好!
这是一份来自人力部发送的2023年薪酬福利报告,感谢您一年来为公司的辛勤付出!
'''
message_text = MIMEText(body_content,"plain","utf-8")
mm.attach(message_text)
#添加附件(excel表格)
f_addr=f"{file_addr.value}"
f_name=f"{file_name.value}"
f_adr=f_addr+"/"+f_name
print(f_adr)
atta = MIMEText(open(f_adr,'rb').read(), 'base64', 'utf-8')
atta["Content-Disposition"] = 'attachment; filename="sample.xlsx"'
mm.attach(atta)
#发送邮件
stp = smtplib.SMTP()
stp.connect(mail_host,25)
stp.login(mail_sender,mail_license)
stp.sendmail(mail_sender, mail_receivers, mm.as_string())
print("邮件发送成功")
stp.quit()