CODEWITHSUNDEEP
pythonhtmlemailpandasmime
GC123
GC123

Reputation: 343

HTML and Text in Python Driven Email

I am using MIMEMultipart to send emails from Python. The code is as follows:

sender = "EMAIL"
recipients = ["EMAIL"]
msg = MIMEMultipart('alternative')
msg['Subject'] = "Subject Text"
msg['From'] = sender
msg['To'] = ", ".join(recipients)

html = PandasDataFrame.to_html()
part2 = MIMEText(html, 'html')
msg.attach(part2)

SERVER = "SERVER"
server = smtplib.SMTP(SERVER)
server.sendmail(sender, recipients, msg.as_string())
server.quit()

This inserts a Python Pandas dataframe as HTML and works fine. Is it possible to add footnotes as text to the email body as well? How would the code work for doing both? Alternatively, I'm fine adding comments as HTML but more of less need some footnotes added to the email body.

Thanks

Upvotes: 0

Views: 2791

Answers (2)

Charlie G
Charlie G

Reputation: 544

So the below didn't work, check out the correct answer

Maybe this? 

html = pd.DataFrame([[1,2,3], ['dog', 'cat', 42]]).to_html()
part1 = MIMEText(html, 'html')
msg.attach(part1)
part2 = MIMEText('html')
coolstring = 'This is a dope-ass DataFrame yo'
part2.set_payload(coolstring)
msg.attach(part2)

though I think it's too similiar to to #2 below. Output follows:

>> print msg
# ...header with my email whoops...
--===============0888735609==
Content-Type: text/html; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
<table border="1" class="dataframe">
    #...DataFrame html...
</table>
--===============0888735609==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
This is a dope-ass DataFrame yo
--===============0888735609==--

Found a couple of ways looking through the examples and by listing out the methods on MIMEMultipart through the equivalent of dir(MIMEMultipart)

Three guesses that you'll have to test:

1) You can set an epilogue by 

msg.epilogue = 'This is a dope-ass DataFrame yo'

Not sure where or if this ends up on the email body however.

2) Create another MIMEText and attach it too. This seems to be how they accomplish sending loads of pictures at once in the examples, so this may be your best bet. Probably should have led with this. 

part_text = MIMEText('This is some text, yessir')
msg.attach(part_text)

It kinda looks like it got there since the boundary divisions are the same. 

>> print msg.as_string()
Content-Type: multipart/alternative; boundary="===============1672307235=="
MIME-Version: 1.0
Subject: Subject Text
From: EMAIL
To: EMAIL
--===============1672307235==
Content-Type: text/html; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
<table border="1" class="dataframe">
  # ...DataFrame in HTML here...
</table>
--===============1672307235==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
This is some text, yessir
--===============1672307235==--

3) Since to actually send it in server.sendmail(sender, recipients, msg.as_string()) you convert msg to a string, your other option would be to manually add some HTML text into msg.as_string() directly. Something like

msg.as_string().replace('</table>', '</table>\n<p>...your text here</p>')

would be messy but should work.

Let me know if any of these are helpful! I'm kinda shooting in the dark because I can't test it right now. Good luck!

Upvotes: 0

GC123
GC123

Reputation: 343

This code works:

First, import:

from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.application import MIMEApplication #Used for attachments
import smtplib

And the code:

sender = "EMAIL"
recipients = ["EMAIL1","EMAIL2"]
msg = MIMEMultipart('mixed') #use mixed instead of alternative to load multiple things 
msg['Subject'] = "Subject Text"
msg['From'] = sender
msg['To'] = ", ".join(recipients)

html = PandasDataFrame1.to_html() #first dataframe

 #insert text as follows
html += '''
    <br><br>
    This is a new line of random text.
    <br><br>
'''

html += PandasDataFrame2.to_html() #second dataframe

#put the html into the email body
html = MIMEText(html, 'html') 
msg.attach(html)

If you also want to attach a file to the email, use this code

ATTACHMENT_PATH = 'path\\file.type'
with open(ATTACHMENT_PATH, 'r') as fileobj:
    attachment = MIMEApplication(fileobj.read(), Name='file.type')
attachment['Content-Disposition'] = 'attachment; filename="file.type"'
msg.attach(attachment)

And the code to send using a server

SERVER = "SERVER"
server = smtplib.SMTP(SERVER)
server.sendmail(sender, recipients, msg.as_string())
server.quit()

Upvotes: 1

Related Questions