一、完整代码及结果
1、代码
#操作excel的工具
import xlrd
import smtplib #登录邮箱,发邮件用的
from email.mime.text import MIMEText #用来包装内容
from email.header import Header #用来包装头信息
# 发送邮件
def send_email(sender_email, sender_password, recipient_email, email_subject, email_content):
try:
smtp_obj = smtplib.SMTP('smtp.qq.com')
smtp_obj.login(sender_email, sender_password)
msg = MIMEText(email_content, 'plain', 'utf-8')
msg['From'] = sender_email #发送者
msg['To'] = recipient_email #接受者
msg['Subject'] = email_subject #主题
smtp_obj.sendmail(sender_email, recipient_email, msg.as_string())
smtp_obj.quit()
print("Email sent successfully.")
except Exception as e:
print("Error sending email:", str(e))
if __name__ == '__main__':
# 打开工作表
data = xlrd.open_workbook('data.xlsx')
# 读取数据并生成相应的内容
sheet = data.sheets()[0] # 打开顶1个sheet
for i in range(sheet.nrows):
name = sheet.cell_value(i, 1)
old_money = sheet.cell_value(i, 2)
new_money = sheet.cell_value(i, 4)
print(name, '---', old_money, '---', new_money)
sender_email = 'your_email@qq.com' # 发件人邮箱
sender_password = 'your_password' # 发件人邮箱密码
recipient_email = 'recipient_email@qq.com' # 收件人邮箱
email_subject = '测试邮件发送' # 邮件主题
email_content = f'{name}你好,由于疫情原因,你的薪资由{old_money}变为{new_money}' # 邮件内容
# 发送邮件
send_email(sender_email, sender_password, recipient_email, email_subject, email_content)
2、结果
二、密码查找
验证登录即可