Python_操作邮箱

最新推荐文章于 2024-10-11 02:04:00 发布

weixin_30692143

最新推荐文章于 2024-10-11 02:04:00 发布

阅读量236

点赞数

文章标签： python 数据库

原文链接：http://www.cnblogs.com/xiaoliwm/p/9635871.html

版权

脚本：

from win32com.client import Dispatch
import datetime as date
import datetime
import re
import win32com.client, sqlite3

sub_today = '转发: 夸客数据导出'
att_KKYQHKJH = 'KKYQHKJH.xlsx'
att_KKYWSJ = 'KKYWSJ.xlsx'

outlook = Dispatch("Outlook.Application").GetNamespace("MAPI") --连接
inbox = outlook.GetDefaultFolder("6")

OlFolderDeletedItems	3	已删除邮件
OlFolderOutbox	4	发件箱
OlFolderSentMail	5	已发件邮件
olFolderInbox	6	收件箱
OlFolderCalendar	9	日历
OlFolderContacts	10	联系人
olFolderJournal	11	日记
olFolderNotes	12	便笺
olFolderTasks	13	任务
olFolderDrafts	16	草稿

begin = datetime.date.today() - datetime.timedelta(days=1)
end = begin + datetime.timedelta(days=1)
filter_string = "[receivedtime] >= '" + begin.strftime("%m/%d/%Y") + "' AND [receivedtime] <= '" + end.strftime("%m/%d/%Y") + "'"
print(filter_string)
print(begin,end)

items = inbox.Items.Restrict(filter_string)

for item in items:

　　if sub_today == item.Subject:

　　　　break

for att1 in item.Attachments:
    if att1.FileName == att_KKYQHKJH:
        att1.SaveAsFile('\\\\FTP.quarkfinance.com\\FTP folder\\催收数据目录\\HLXYD\\KKYQHKJH.xlsx ') ---保存地址
        print(att_KKYQHKJH,item.receivedtime)

for att2 in item.Attachments:
    if att2.FileName == att_KKYWSJ:
        att2.SaveAsFile('\\\\FTP.quarkfinance.com\\FTP folder\\催收数据目录\\HLXYD\\KKYWSJ.xlsx ')
        print(att_KKYWSJ,item.receivedtime)

转载于:https://www.cnblogs.com/xiaoliwm/p/9635871.html