23 lines
707 B
Python
23 lines
707 B
Python
import pandas
|
|
from sendmail import *
|
|
|
|
if __name__ == '__main__':
|
|
df = pandas.read_excel("./스마트스토어_전체주문발주발송관리_20220915_0938.xls")
|
|
df_playauto = pandas.read_excel("./아트박스_주문파일취합_2202_0908.xlsx")
|
|
df_artbox = pandas.read_excel("./플레이오토_주문용파일취합_2022_0908.xlsx")
|
|
print(df)
|
|
print(df_playauto)
|
|
print(df_artbox)
|
|
|
|
to = 'maddiekorea@gmail.com'
|
|
title = "Test"
|
|
contents = """6...7"""
|
|
attachments = "/Users/maddiekorea/PycharmProjects/automations/플레이오토_주문취합_다운로드파일_필드전체적용_샘플.xlsx"
|
|
|
|
mail = sendmail(to, title, contents, attachments)
|
|
mail.smtprun()
|
|
|
|
|
|
|
|
|