Django - Send a Mail with Attachment File like CSV

django_send_mail

# Import EmailMessage class - https://docs.djangoproject.com/en/1.9/topics/email/#django.core.mail.EmailMessage
from django.core.mail import EmailMessage
email = EmailMessage('... Subject ...', '... Body ...', 'from-email',
            ['to-email-1', 'to-email-2'], ['bcc-email-1', 'bcc-email-2'])

# now let's create a csv file dynamically
import csv, StringIO
attachment_csv_file = StringIO.StringIO()

writer = csv.writer(attachment_csv_file)

labels = ['name', 'city', 'email']
writer.writerow(labels)

rows = [['Nitin', 'Bengaluru', '[email protected]'], ['X', 'Y', 'Z']]

for row in rows:
    writer.writerow(row)

email.attach('attachment_file_name.csv', attachment_csv_file.getvalue(), 'text/csv')
email.send(fail_silently=False)

Thanks