#-*-coding:utf-8-*-

from email.mime.multipart import MIMEMultipart
from email.mime.base import MIMEBase
from email.mime.text import MIMEText
from email.utils import COMMASPACE, formatdate
from email import encoders
import smtplib
import os,datetime


time_now = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
time_path = datetime.datetime.now().strftime('%Y-%m-%d')


# 發(fā)送郵件
def send_mail(server, fro, to, subject, htmlText, files=[]):
    try:
        msg = MIMEMultipart()
        msg['From'] = fro
        msg['Subject'] = subject
        msg['To'] = COMMASPACE.join(to)  # COMMASPACE==', '
        msg['Date'] = formatdate(localtime=True)
        # 'alternative' part, so message agents can decide which they want to display.

        msgAlternative = MIMEMultipart('alternative')
        msg.attach(msgAlternative)
        msgText = MIMEText(htmlText, 'html', 'utf-8')
        msgAlternative.attach(msgText)

        for f in files:
            part = MIMEBase('application', 'octet-stream')  # 'octet-stream': binary data
            part.set_payload(open(f, 'rb').read())
            encoders.encode_base64(part)
            part.add_header('Content-Disposition', 'attachment; filename="%s"' % os.path.basename(f))
            msg.attach(part)

        smtp = smtplib.SMTP(server['name'], server['port'])
        smtp.ehlo()
        smtp.starttls()
        smtp.ehlo()
        smtp.login(server['user'], server['passwd'])
        smtp.sendmail(fro, to, msg.as_string())
        smtp.close()
        return True
    except Exception as e:
        print repr(e)
        return False

def export_html():
    htmlText = '''
        <p>您好鞋拟，<br/>
         &nbsp;&nbsp;內(nèi)容（請(qǐng)見(jiàn)附件）
         </p>
    '''
    htmlText += 'from who' + '<br/><br/>'
    htmlText += 'Have a good day!'
    return htmlText

# 絕對(duì)路徑 file_path = os.getcwd() + r"\\2018-03-13.xls" 
# 上一級(jí)os.path.join(os.path.dirname("__file__"), os.path.pardir)  再上一級(jí)就加os.path.pardir：os.path.join(os.path.dirname("__file__"), os.path.pardir,os.path.pardir)

file_path = os.path.abspath(os.path.join(os.path.dirname("__file__"))) + r"\execl\%s.xls" %time_path
# print file_path
text = export_html()

#發(fā)送人郵箱
fro = 'xxxx@qq.com'
#收件人郵箱和抄送
# to = ['xxx@qq.com','xxxx@163.com']
to = ['xxxx@.com.cn']

郵件主題
subject = u'xxxxxxxxxxxx.'

mailserver_conf={'name':'發(fā)件人名稱',
         'user':'用戶名賬號(hào)',
         'passwd':'密碼',
         'port':端口號(hào),
         }

send_mail(mailserver_conf,fro,to,subject,text,files=[file_path])
print '發(fā)送成功'