How to send an email with attachment?

Question

Using xlwt I have created an Excel sheet that with Django I would like to email as an attachment.

response = HttpResponse(mimetype='application/ms-excel')
response['Content-Disposition'] = 'attachment; filename='Report.xls'

book = xlwt.Workbook()
sheet = book.add_sheet("Core Listings")

book.save(response)
return response

I am using Django EmailMessage to send out emails.

Possible duplicate of [sending-emails-with-attachment-in-django](https://stackoverflow.com/questions/2457906/sending-emails-with-attachment-in-django) — Oliver W., Oct 28 '14 at 17:02
Did you try either the `attachments` argument to the constructor or the `attach()` method? — Ignacio Vazquez-Abrams, Oct 28 '14 at 17:07
Yes But I am not saving that to disk, So How can I use attach()? — NAGARJUNA PALURU, Oct 28 '14 at 17:08
Use a [tmp file](https://docs.python.org/2/library/os.html?highlight=tmpfile#os.tmpfile)? — matsjoyce, Oct 28 '14 at 17:30
It probably supports a file-like object like you get from `StringIO`. — Brian Cain, Oct 28 '14 at 17:30

score 0 · Answer 1 · answered Mar 30 '15 at 19:20

0

You should be able to create a MimeBase object in memory from the spreadsheet data and attach that object in the attach method. The attach method takes the file triplet or a MimeBase object. See pydoc description about MimeBase and an example.

answered Mar 30 '15 at 19:20

devinformatics

72
6

How to send an email with attachment?

1 Answers1

Linked