Sending personalized mass emails with different attachments

July 8, 2019 0 Comments

Here comes another challenge for this week. So, you are organizing an event, and some people will pay the costs via bank transfer. Therefore, you need to send email attachments (including banking details) to only those people who want to use that payment option. Let us also assume that you gave them IDs to recognize their payment. In the document that you will attach, you want to include those IDs as well, and that makes each document unique to each recipient. No problem.

import csv
import re
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.mime.base import MIMEBase
from email import encoders

subject = 'subject'
email_data = csv.reader(open('email.csv', 'r'))
email_pattern= re.compile("^.+@.+\..+$")
for row in email_data:
    msg = MIMEMultipart()
    msg['From'] = 'your email'
    msg['Subject'] = subject

    fp = open('message.txt', 'r')
    body = MIMEText(


    server = smtplib.SMTP('hostname', portnumber)
    server.login('your email', 'your password')
    if([1]) ):
        del msg['To']
        msg['To'] = row[1]
    if(len(row) >= 5 and len(row[4]) > 0):
        filename = row[4] + '.docx'
        attachment = open(filename, 'rb')
        part = MIMEBase('application', 'octet-stream')
        part.add_header('Content-Disposition', "attachment; filename= " + filename)


    server.sendmail('your email', [row[1]], msg.as_string().format(row[0], row[2], row[3]))


I created a for loop for each email. The reason being that you can overwrite the text for each email with varying information. However, you cannot overwrite attachment. You either need to delete the attachment or treat each email as a different object. I chose the latter. The names of attachments were in the row[4] in the email.csv file. On line 30, you will see an if statement. If the number of rows is equal to 5 or bigger, and there is a row[4], it means that we have to add an attachment. For the people who did not want to use that payment option, we will leave this row empty.

To see the previous blogs about sending mass emails, see here and here.

Leave a Reply

Your email address will not be published. Required fields are marked *