import smtplib

smtp = smtplib.SMTP()
smtp.connect(host, port)  # 與服務器進行連接
smtp.set_debuglevel(1) #顯示出交互信息
smtp.login(username, password)  # 登陸郵箱
smtp.sendmail(sender, receiver, msg.as_string())  # 發(fā)送郵件
smtp.quit()  # 斷開連接

import smtplib
from email.mime.multipart import MIMEMultipart 
from email import encoders
from email.header import Header
from email.mime.text import MIMEText
from email.utils import parseaddr, formataddr
from email.mime.application import MIMEApplication

#發(fā)件人郵箱
asender="zhangjunhongdata@163.com"
#收件人郵箱
areceiver="zhangjunhong@163.com"
#抄送人郵箱
acc = 'zhangjunhong@qq.com'
#郵件主題
asubject = '這是一份測試郵件'  

#發(fā)件人地址
from_addr = "zhangjunhongdata@163.com"
#郵箱密碼（授權碼）
password="123data"

#郵件設置
msg = MIMEMultipart()
msg['Subject'] = asubject  
msg['to'] = areceiver  
msg['Cc'] = acc 
msg['from'] =  "張俊紅"

#郵件正文
body = "你好，這是一份測試郵件"

#添加郵件正文:
msg.attach(MIMEText(body, 'plain', 'utf-8'))

#添加附件
#注意這里的文件路徑是斜杠
xlsxpart = MIMEApplication(open('C:/Users/zhangjunhong/Desktop/這是附件.xlsx', 'rb').read())
xlsxpart.add_header('Content-Disposition', 'attachment', filename='這是附件.xlsx')
msg.attach(xlsxpart)    

#設置郵箱服務器地址以及端口
smtp_server ="smtp.163.com"
server = smtplib.SMTP(smtp_server, 25)
server.set_debuglevel(1)

#登陸郵箱
server.login(from_addr, password)

#發(fā)送郵件
server.sendmail(from_addr, areceiver.split(',')+acc.split(','), msg.as_string())

#斷開服務器鏈接
server.quit()

import smtplib
from email.mime.multipart import MIMEMultipart 
from email.mime.text import MIMEText
from email.mime.image import MIMEImage
from email.mime.application import MIMEApplication

host = "smtp.163.com"
port = 25
username = "zhangjunhong1227@163.com"
password = "123zjh"

smtp = smtplib.SMTP() #聲明一個鏈接對象
smtp.connect(host, port)  # 與服務器進行連接
smtp.set_debuglevel(1) #顯示出交互信息
smtp.login(username, password)  # 登陸郵箱

sender = username

for i in zip(df["姓名"],df["收件人"],df["抄送人"]):
    
    receiver = i[1] #收件人
    acc = i[2] #抄送人


    msg = MIMEMultipart() #聲明一個郵件對象
    msg['from'] = username #發(fā)件人
    msg['to'] = receiver#收件人
    msg['Cc'] = acc #抄送人
    msg['Subject'] = i[0] + "任務明細" #主題

    # 編寫正文
    text = MIMEText(i[0]+"您好，這是您這個月的任務明細",'plain', 'utf-8') 
    msg.attach(text)

    # 添加表格附件
    f = open('C:/Users/zhangjunhong/Desktop/任務明細/'+ i[0] + '.xlsx', 'rb').read()
    filepart = MIMEApplication(f)
    filepart.add_header('Content-Disposition','attachment',filename=i[0] + '任務明細.xlsx') #為附件添加一個標題
    msg.attach(filepart)

    smtp.sendmail(sender, receiver.split(',') + acc.split(','), msg.as_string())  # 發(fā)送郵件
smtp.quit()  # 斷開連接