As part of reporting in business intelligence, scheduled emails are a very useful tool. They allow you to send various daily summaries, or attach larger reports.
For these purposes I put together a Python BI-mailer class to allow for easy management of all things you might normally require to send, such as text, summary/KPI html tables, embedded images or charts, or attach larger reports.
I will put the code here, and in the next articles I will give examples of how to use this easy Python emailer to accomplish daily reporting chores.
With this script you are able to:
send an email
optionally with text or multiple tables in body
optionally with attachments
optionally use the attachments as embedded images.
|
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 |
#to query: import sys import ast from datetime import datetime import smtplib import mimetypes from email.mime.multipart import MIMEMultipart from email import encoders from email.message import Message from email.mime.audio import MIMEAudio from email.mime.base import MIMEBase from email.mime.image import MIMEImage from email.mime.text import MIMEText class Bimail: def __init__(self,subject,recipients): self.subject = subject self.recipients = recipients self.htmlbody = '' self.sender = "mailsender135@gmail.com" self.senderpass = 'mailsender135.' self.attachments = [] def send(self): msg = MIMEMultipart('alternative') msg['From']=self.sender msg['Subject']=self.subject msg['To'] = ", ".join(self.recipients) # to must be array of the form ['mailsender135@gmail.com'] msg.preamble = "preamble goes here" #check if there are attachments if yes, add them if self.attachments: self.attach(msg) #add html body after attachments msg.attach(MIMEText(self.htmlbody, 'html')) #send s = smtplib.SMTP('smtp.gmail.com:587') s.starttls() s.login(self.sender,self.senderpass) s.sendmail(self.sender, self.recipients, msg.as_string()) #test print msg s.quit() def htmladd(self, html): self.htmlbody = self.htmlbody+'<p></p>'+html def attach(self,msg): for f in self.attachments: ctype, encoding = mimetypes.guess_type(f) if ctype is None or encoding is not None: ctype = "application/octet-stream" maintype, subtype = ctype.split("/", 1) if maintype == "text": fp = open(f) # Note: we should handle calculating the charset attachment = MIMEText(fp.read(), _subtype=subtype) fp.close() elif maintype == "image": fp = open(f, "rb") attachment = MIMEImage(fp.read(), _subtype=subtype) fp.close() elif maintype == "audio": fp = open(f, "rb") attachment = MIMEAudio(fp.read(), _subtype=subtype) fp.close() else: fp = open(f, "rb") attachment = MIMEBase(maintype, subtype) attachment.set_payload(fp.read()) fp.close() encoders.encode_base64(attachment) attachment.add_header("Content-Disposition", "attachment", filename=f) attachment.add_header('Content-ID', '<{}>'.format(f)) msg.attach(attachment) def addattach(self, files): self.attachments = self.attachments + files #example below if __name__ == '__main__': # subject and recipients mymail = Bimail('Sales email ' +datetime.now().strftime('%Y/%m/%d'), ['recipient1@gmail.com', 'recipient2@gmail.com']) #start html body. Here we add a greeting. mymail.htmladd('Good morning, find the daily summary below.') #Further things added to body are separated by a paragraph, so you do not need to worry about newlines for new sentences #here we add a line of text and an html table previously stored in the variable mymail.htmladd('Daily sales') mymail.htmladd(htmlsalestable) #another table name + table mymail.htmladd('Daily bestsellers') mymail.htmladd(htmlbestsellertable) # add image chart title mymail.htmladd('Weekly sales chart') #attach image chart mymail.addattach(['saleschartweekly.jpg']) #refer to image chart in html mymail.htmladd('<img src="cid:saleschartweekly.jpg"/>') #attach another file mymail.addattach(['bimail.py']) #send! mymail.send() |