diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/mailing_list.py | 21 |
1 files changed, 11 insertions, 10 deletions
diff --git a/python/mailing_list.py b/python/mailing_list.py index 40b7e901..90a12d87 100644 --- a/python/mailing_list.py +++ b/python/mailing_list.py @@ -3,38 +3,39 @@ from email.mime.application import MIMEApplication from email.mime.multipart import MIMEMultipart from email.mime.text import MIMEText from string import Template -from config import gmail_password -from email.utils import make_msgid, formatdate +from config import gmail_login, gmail_password import os import csv import sys +import xlrd root = "/home/share/serenitas/Fund Raising" -with open(os.path.join(root, sys.argv[1]), "r", encoding='cp1252') as fh: - csvreader = csv.DictReader(fh) - mailing_list = [(line["Email"], line["Name"]) for line in csvreader if line["Include?"]=="y"] +book = xlrd.open_workbook(os.path.join(root, sys.argv[1])) +sheet = book.sheet_by_name("Distribution List") +emails, names, include = sheet.col(4), sheet.col(5), sheet.col(6) +mailing_list = [(emails[i].value, names[i].value) for i, y in enumerate(include[3:], 3) if y.value=="y"] #SMTP server server = smtplib.SMTP('smtp.gmail.com:587') server.starttls() -server.login("david.weeks@serenitascapital.com", gmail_password) +server.login(gmail_login, gmail_password) -with open("template-2014-03-11.txt") as fh: +with open("template-2014-03-12.txt") as fh: s_text = Template(fh.read()) -with open("template-2014-03-11.html") as fh: +with open("template-2014-03-12.html") as fh: s_html = Template(fh.read()) attachment_name = 'Serenitas Capital (SCGMF Returns).pdf' -with open(os.path.join(root, "Pitchbook", attachment_name, 'rb'), 'rb') as fh: +with open(os.path.join(root, "Pitchbook", attachment_name), 'rb') as fh: pdf_attach = MIMEApplication(fh.read(), 'pdf') pdf_attach.add_header('Content-Disposition', 'attachment', filename = attachment_name) for email, name in mailing_list: msg = MIMEMultipart() msg['Subject'] = 'Serenitas Credit Gamma Master Fund performance update' - msg['From'] = 'david.weeks@serenitascapital.com' + msg['From'] = gmail_login msg['To'] = email msg_alternative = MIMEMultipart('alternative') msg_alternative.attach(MIMEText(s_text.substitute(name = name),'plain')) |