看我用 Python 一秒發(fā)送數(shù)百份郵件，讓財務(wù)部妹子追著喊 666！

需求描述

“

尊敬的xxx部門 xxx 您好，您的工號是 xxx，您 2020 年的獎金為 xxx

”

邏輯梳理

“

• 逐行遍歷 郵件地址.xlsx 取各部門名稱和負責(zé)人郵箱地址

• 根據(jù)部門名稱去 獎金發(fā)放 文件夾下獲取 獎金_部門名稱.xlsx 作為附件

• 再遍歷 郵件地址.xlsx的循環(huán)體內(nèi)完成郵件的發(fā)送

”

代碼實現(xiàn)

from?openpyxl?import?load_workbook
import?yagmail
import?keyring

password?=?keyring.get_password('yagmail',?'username')
#?需要在命令號中用?keyring.set_password('yagmail',?username,?password)?預(yù)先存好

path?=?r'C:\xxx'?#?根據(jù)實際附件文件和郵件地址?Excel?文件存放的路徑確定
workbook?=?load_workbook(path?+?r'\郵件地址.xlsx')
sheet?=?workbook.active

n?=?0?#?設(shè)置變量跳過表頭
for?row?in?sheet.rows:
????if?n:
????????department?=?row[0].value
????????dep_address?=?row[1].value
????????print(department,?dep_address)
????n?+=?1

#?用服務(wù)器、用戶名、密碼實例化郵件
mail?=?yagmail.SMTP(user='[email protected]',?password?=?password,?host='smtp.qq.com')?
#?待發(fā)送的內(nèi)容
contents?=?['第一段內(nèi)容',?'第二段內(nèi)容']
#?發(fā)送郵件
mail.send('收件人郵箱',?'郵件標(biāo)題',?contents)?

n?=?0
for?row?in?sheet.rows:
????if?n:
????????department?=?row[0].value
????????dep_address?=?row[1].value
????????#?print(department,?dep_address)
????????mail_dep?=?yagmail.SMTP(user='[email protected]',?password=password,?host='smtp.qq.com')
????????contents?=?[f'您好，請查收{department}的獎金情況',?path?+?f'\獎金發(fā)放\獎金_{department}']
????????mail_dep.send(dep_address,?f'{department}獎金情況',?contents)
????n?+=?1

n?=?0
for?row?in?sheet.rows:
????if?n:
????????department?=?row[0].value
????????dep_address?=?row[1].value
????????#?print(department,?dep_address)
????????mail_dep?=?yagmail.SMTP(user='[email protected]',?password=password,?host='smtp.qq.com')

????????#?這一部分就是升級需求的代碼
????????#?根據(jù)前面的部門信息打開相應(yīng)的表格獲取每個人的情況
????????workbook_new?=?load_workbook(path?+?f'\獎金發(fā)放\獎金_{department}')
????????sheet_new?=?workbook_new.active
????????m?=?0
????????for?i?in?sheet_new.rows:
????????????if?m:
????????????????id?=?i[0].value?#?工號
????????????????name?=?i[1].value?#?姓名
????????????????address?=?i[2].value?#?個人郵箱地址
????????????????money?=?i[3].value?#?獎金數(shù)
????????????????#?根據(jù)獲取到的個人信息組裝成新的郵件發(fā)送
????????????????mail?=?yagmail.SMTP(user='[email protected]',?password=password,?host='smtp.qq.com')
????????????????contents?=?[f'尊敬的?{department}?{name}?您好，您的工號是?{id}，您2020年的獎金為?{money}']
????????????????mail.send(address,?f'{department}-{name}獎金情況',?contents)????????????????
????????????m?+=?1

????????contents_dep?=?[f'您好，請查收{department}的獎金情況',?path?+?f'\獎金發(fā)放\獎金_{department}']
????????mail_dep.send(dep_address,?f'{department}獎金情況',?contents_dep)
????n?+=?1

至此，短短 30 余行代碼就成功安撫了妹子交集的心態(tài)，并約個飯希望好好聊一聊如何用 Python 偷懶，這些就不再分享了

點個在看你最好看