1 files changed, 45 insertions, 0 deletions
diff --git a/python/mailing_list.py b/python/mailing_list.py
new file mode 100644
index 00000000..40b7e901
--- /dev/null
+++ b/python/mailing_list.py
@@ -0,0 +1,45 @@
+import smtplib
+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
+import os
+import csv
+import sys
+
+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"]
+
+#SMTP server
+server = smtplib.SMTP('smtp.gmail.com:587')
+server.starttls()
+server.login("david.weeks@serenitascapital.com", gmail_password)
+
+with open("template-2014-03-11.txt") as fh:
+    s_text = Template(fh.read())
+
+with open("template-2014-03-11.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:
+    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['To'] = email
+    msg_alternative = MIMEMultipart('alternative')
+    msg_alternative.attach(MIMEText(s_text.substitute(name = name),'plain'))
+    msg_alternative.attach(MIMEText(s_html.substitute(name = name),'html'))
+    msg.attach(msg_alternative)
+    msg.attach(pdf_attach)
+    server.send_message(msg)
+server.quit()