个人中心
gpt4 book ai didi

python脚本定时发送邮件

转载 作者：qq735679552 更新时间：2022-09-29 22:32:09 26 4
gpt4 key购买 nike

CFSDN坚持开源创造价值，我们致力于搭建一个资源共享平台，让每一个IT人在这里找到属于你的精彩世界.

这篇CFSDN的博客文章python脚本定时发送邮件由作者收集整理，如果你对这篇文章有兴趣，记得点赞哟.

本文实例为大家分享了python定时发送邮件的具体代码，供大家参考，具体内容如下 。

全部代码如下:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
import time
from datetime import datetime
from email.header import Header
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.utils import parseaddr, formataddr
 
import xlrd
from apscheduler.schedulers.blocking import BlockingScheduler
from xlrd import xldate_as_tuple
 
ISOTIMEFORMAT = '%Y%m%d'
import smtplib
 
 
def read_file(file_path):
   file_list = []
   work_book = xlrd.open_workbook(file_path)
   sheet_data = work_book.sheet_by_name( 'Sheet1' )
   print ( 'now is process :' , sheet_data.name)
   Nrows = sheet_data.nrows
 
   for i in range ( 1 , Nrows):
     file_list.append(sheet_data.row_values(i))
 
   return file_list
 
 
def _format_addr(s):
   name, addr = parseaddr(s)
   return formataddr((Header(name, 'utf-8' ).encode(), addr))
 
 
def sendEmail(from_addr, password, to_addr, smtp_server, file_list):
   nowDate = str (time.strftime(ISOTIMEFORMAT, time.localtime()))
   html_content_start = \
     '''
     <html>
     <body>
       <p>hi，All：</p>
       <table border="0"width="95%"height="50%"cellpadding="1"style="margin:15px"cellspacing="1"bordercolor="#D3D3D3"bgcolor="#9F9F9F">
         <tr bgcolor="#D3D3D3" style="margin:10px">
           <th style="padding:6;font-size:16">工作事项</th>
           <th style="padding:6;font-size:16">负责人</th>
           <th style="padding:6;font-size:16">进度</th>
           <th style="padding:6;font-size:16">风险与问题</th>
         </tr>
     '''
   for i in range ( len (file_list)):
     work = file_list[i]
     workdata, person_name, progress, issue = str (work[ 0 ]), str (work[ 1 ]), str (work[ 2 ]), str (work[ 3 ])
     if '.' in str (work[ 2 ]): # 填的数字
       progress = "%.0f%%" % (work[ 2 ] * 100 ) # 浮点转成百分比
 
     updateTime = xldate_as_tuple(work[ 4 ], 0 )
     value = datetime( * updateTime)
     # 先转换为时间数组,然后转换为其他格式
     timeStruct = time.strptime( str (value), "%Y-%m-%d %H:%M:%S" )
     uptTime = str (time.strftime( "%Y%m%d" , timeStruct))
     if uptTime ! = nowDate:
       raise RuntimeError( '有人没有更新最新记录:' + str (work[ 1 ]))
 
     html_content_suffer = \
       '''
           <tr bgcolor="#FFFFFF" >
             <td style="padding:6;font-size:14">{workdata}</td>
             <td style="padding:6;font-size:14">{person_name}</td>
             <td style="padding:6;font-size:14">{progress}</td>
             <td style="padding:6;font-size:14">{issue}</td>
           </tr>
       ''' . format (workdata = workdata.replace('\n ', ' <br>'), person_name = person_name, progress = progress, issue = issue)
     html_content_start + = html_content_suffer
 
   html_content_end = \
     '''
       </table>
     </body>
     </html>
     '''
   html_content = html_content_start + html_content_end
 
   try :
     msg = MIMEMultipart()
     msg.attach(MIMEText(html_content, 'html' , 'utf-8' ))
     msg[ 'From' ] = _format_addr( '发送方 <%s>' % from_addr)
     msg[ 'To' ] = _format_addr(to_addr + '<%s>' % to_addr)
     msg[ 'Subject' ] = Header( '主题' + nowDate, 'utf-8' ).encode()
 
     server = smtplib.SMTP_SSL(smtp_server, 465 )
     server.login(from_addr, password) # 登录邮箱服务器
     server.sendmail(from_addr, [to_addr], msg.as_string()) # 发送信息
     server.quit()
     print ( "from_addr：" + str (from_addr), " to_addr：" , to_addr, "已发送成功！" )
   except Exception as e:
     print ( "发送失败" + e)
 
 
def job():
   root_dir = 'D:\\develop\\python\\file'
   file_path = root_dir + "\\excel.xlsx"
   from_addr = 'aaa@163.com' # 邮箱登录用户名
   password = 'mima' # 登录密码
   smtp_server = 'smtp.com' # 服务器地址，默认端口号25
   to_addr = 'aaa@163.com' # 接收方邮箱
 
   file_list = read_file(file_path)
   sendEmail(from_addr, password, to_addr, smtp_server, file_list)
   print ( '发送完成' )
 
 
if __name__ = = '__main__' :
   # 该示例代码生成了一个BlockingScheduler调度器，使用了默认的任务存储MemoryJobStore，以及默认的执行器ThreadPoolExecutor，并且最大线程数为10。
 
   # BlockingScheduler：在进程中运行单个任务，调度器是唯一运行的东西
   scheduler = BlockingScheduler()
   # 采用阻塞的方式
 
   # 采用corn的方式，每天18点发送
   scheduler.add_job(job, 'cron' , hour = '18' )
   '''
     year (int|str) – 4-digit year
     month (int|str) – month (1-12)
     day (int|str) – day of the (1-31)
     week (int|str) – ISO week (1-53)
     day_of_week (int|str) – number or name of weekday (0-6 or mon,tue,wed,thu,fri,sat,sun)
     hour (int|str) – hour (0-23)
     minute (int|str) – minute (0-59)
     econd (int|str) – second (0-59)
     start_date (datetime|str) – earliest possible date/time to trigger on (inclusive)
     end_date (datetime|str) – latest possible date/time to trigger on (inclusive)
     timezone (datetime.tzinfo|str) – time zone to use for the date/time calculations (defaults to scheduler timezone)
     *  any  Fire on every value
     */a  any  Fire every a values, starting from the minimum
     a-b  any  Fire on any value within the a-b range (a must be smaller than b)
     a-b/c  any  Fire every c values within the a-b range
     xth y  day  Fire on the x -th occurrence of weekday y within the month
     last x  day  Fire on the last occurrence of weekday x within the month
     last  day  Fire on the last day within the month
     x,y,z  any  Fire on any matching expression; can combine any number of any of the above expressions
     '''
   scheduler.start()

表格如下:

python脚本定时发送邮件

如果放在linux系统中执行，上述脚本不能执行成功，是因为对编码等有要求，全部更新代码如下:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
#coding=utf-8
import time
from datetime import datetime
from email.header import Header
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.utils import parseaddr, formataddr
 
import sys
 
import xlrd
from apscheduler.schedulers.blocking import BlockingScheduler
from xlrd import xldate_as_tuple
 
ISOTIMEFORMAT = '%Y%m%d'
import smtplib
import logging
logging.basicConfig()
 
def read_file(file_path):
   file_list = []
   work_book = xlrd.open_workbook(file_path)
   sheet_data = work_book.sheet_by_name( 'Sheet1' )
   print ( 'now is process :' , sheet_data.name)
   Nrows = sheet_data.nrows
 
   for i in range ( 1 , Nrows):
     file_list.append(sheet_data.row_values(i))
 
   return file_list
 
 
def _format_addr(s):
   name, addr = parseaddr(s)
   return formataddr((Header(name, 'utf-8' ).encode(), addr))
 
 
def sendEmail(from_addr, password, to_addr, smtp_server, file_list):
   nowDate = str (time.strftime(ISOTIMEFORMAT, time.localtime()))
   html_content_start = \
     '''
     <html>
     <body>
       <p>hi，All：</p>
       <table border="0"width="95%"height="50%"cellpadding="1"style="margin:15px"cellspacing="1"bordercolor="#D3D3D3"bgcolor="#9F9F9F">
         <tr bgcolor="#D3D3D3" style="margin:10px">
           <th style="padding:6;font-size:16">工作事项</th>
           <th style="padding:6;font-size:16">负责人</th>
           <th style="padding:6;font-size:16">进度</th>
           <th style="padding:6;font-size:16">风险与问题</th>
         </tr>
     '''
   for i in range ( len (file_list)):
     work = file_list[i]
     workdata, person_name, progress, issue = str (work[ 0 ]), str (work[ 1 ]), str (work[ 2 ]), str (work[ 3 ])
     if '.' in str (work[ 2 ]): # 填的数字
       progress = "%.0f%%" % (work[ 2 ] * 100 ) # 浮点转成百分比
 
     updateTime = xldate_as_tuple(work[ 4 ], 0 )
     value = datetime( * updateTime)
     # 先转换为时间数组,然后转换为其他格式
     timeStruct = time.strptime( str (value), "%Y-%m-%d %H:%M:%S" )
     uptTime = str (time.strftime( "%Y%m%d" , timeStruct))
     if uptTime ! = nowDate:
       raise RuntimeError( '有人没有更新最新记录:' + str (work[ 1 ]))
 
     html_content_suffer = \
       '''
           <tr bgcolor="#FFFFFF" >
             <td style="padding:6;font-size:14">{workdata}</td>
             <td style="padding:6;font-size:14">{person_name}</td>
             <td style="padding:6;font-size:14">{progress}</td>
             <td style="padding:6;font-size:14">{issue}</td>
           </tr>
       ''' . format (workdata = workdata.replace('\n ', ' <br> '), person_name=person_name.replace(' \n ', ' <br> '), progress=progress.replace(' \n ', ' <br> '), issue=issue.replace(' \n ', ' <br>'))
     html_content_start + = html_content_suffer
 
   html_content_end = \
     '''
       </table>
     </body>
     </html>
     '''
   html_content = html_content_start + html_content_end
 
   try :
     msg = MIMEMultipart()
     msg.attach(MIMEText(html_content, 'html' , 'utf-8' ))
     msg[ 'From' ] = _format_addr( '发送方 <%s>' % from_addr)
     msg[ 'To' ] = _format_addr(to_addr + '<%s>' % to_addr)
     msg[ 'Subject' ] = Header( '主题' + nowDate, 'utf-8' ).encode()
 
     server = smtplib.SMTP_SSL(smtp_server, 465 )
     server.login(from_addr, password) # 登录邮箱服务器
     server.sendmail(from_addr, [to_addr], msg.as_string()) # 发送信息
     server.quit()
     print ( "from_addr：" + str (from_addr), " to_addr：" , to_addr, "已发送成功！" )
   except Exception as e:
     print ( "发送失败" + e)
 
 
def job():
   root_dir = 'D:\\develop\\python\\file'
   file_path = root_dir + "\\excel.xlsx"
   from_addr = 'aaa@163.com' # 邮箱登录用户名
   password = 'mima' # 登录密码
   smtp_server = 'smtp.com' # 服务器地址，默认端口号25
   to_addr = 'aaa@163.com' # 接收方邮箱
 
   file_list = read_file(file_path)
   sendEmail(from_addr, password, to_addr, smtp_server, file_list)
   print ( '发送完成' )
 
 
if __name__ = = '__main__' :
   # 该示例代码生成了一个BlockingScheduler调度器，使用了默认的任务存储MemoryJobStore，以及默认的执行器ThreadPoolExecutor，并且最大线程数为10。
 
   # BlockingScheduler：在进程中运行单个任务，调度器是唯一运行的东西
   scheduler = BlockingScheduler()
   # 采用阻塞的方式
 
   reload (sys)
 
   sys.setdefaultencoding( "utf8" )
 
   # 采用corn的方式
   scheduler.add_job(job, 'cron' , hour = '21' , minute = '0' )
   '''
     year (int|str) – 4-digit year
     month (int|str) – month (1-12)
     day (int|str) – day of the (1-31)
     week (int|str) – ISO week (1-53)
     day_of_week (int|str) – number or name of weekday (0-6 or mon,tue,wed,thu,fri,sat,sun)
     hour (int|str) – hour (0-23)
     minute (int|str) – minute (0-59)
     econd (int|str) – second (0-59)
     start_date (datetime|str) – earliest possible date/time to trigger on (inclusive)
     end_date (datetime|str) – latest possible date/time to trigger on (inclusive)
     timezone (datetime.tzinfo|str) – time zone to use for the date/time calculations (defaults to scheduler timezone)
     *  any  Fire on every value
     */a  any  Fire every a values, starting from the minimum
     a-b  any  Fire on any value within the a-b range (a must be smaller than b)
     a-b/c  any  Fire every c values within the a-b range
     xth y  day  Fire on the x -th occurrence of weekday y within the month
     last x  day  Fire on the last occurrence of weekday x within the month
     last  day  Fire on the last day within the month
     x,y,z  any  Fire on any matching expression; can combine any number of any of the above expressions
     '''
   scheduler.start()

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持我.

原文链接：https://blog.csdn.net/qq_35956041/article/details/102574867 。

最后此篇关于python脚本定时发送邮件的文章就讲到这里了,如果你想了解更多关于python脚本定时发送邮件的内容请搜索CFSDN的文章或继续浏览相关文章，希望大家以后支持我的博客！ 。

26 4 0
文章推荐： python实现定时发送邮件到指定邮箱
文章推荐： python实现定时发送邮件
文章推荐： 如何用python批量调整视频声音
文章推荐： 分享一个python的aes加密代码
qq735679552
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com