我已经编写了一个脚本,它可以向Excel表中的所有联系人发送单独的电子邮件。表如下所示:
Names Emails PDF
Name1 Email1@email.com PDF1.pdf
Name2 Email2@email.com PDF2.pdf
我目前掌握的代码如下:
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.mime.base import MIMEBase
from email import encoders
from string import Template
import pandas as pd
e = pd.read_excel("Contacts.xlsx")
emails = e['Email'].values
PDF = e['PDF'].values
print(emails, PDF)
server = smtplib.SMTP(host='smtp.outlook.com', port=587)
server.starttls()
server.login('sender_email','sender_password')
msg = ("""
Hi there
Test message
Thankyou
""")
subject = "Send emails with attachment"
body = "Subject: {}\n\n{}".format(subject,msg)
for emails in emails:
server.sendmail('sender_email',emails,body)
print("Emails sent successfully")
server.quit()
问题:如何查找每个电子邮件地址(第2列)的正确附件(第3列)并使用Python将其附加到电子邮件?你知道吗
我做了一些修改,确保pdf字段有pdf路径 编辑:
相关问题 更多 >
编程相关推荐