Python 自动发邮件+附件

# -*- coding: utf-8 -*-
"""
Created on Fri Nov  5 18:10:00 2021

@author: yalan.pan
"""
import win32com.client as win32
import warnings
import sys
import pythoncom
import importlib

importlib.reload(sys)

warnings.filterwarnings('ignore')
pythoncom.CoInitialize()
def sendmail():
    sub = 'outlook python mail test'
    body = 'my test\r\n my python mail'
    outlook = win32.Dispatch('outlook.application')
    receivers = ['toyouxiangname']
    mail = outlook.CreateItem(0)
    mail.To = receivers[0]
    mail.Subject = sub
    mail.Body = body
    #mail.Subject = sub.decode('utf-8')  #提示str没有decode，故略去
    #mail.Body = body.decode('utf-8')

    mail.Attachments.Add(r'book1.xlsx')
    mail.Send()
 
sendmail()