topic How to display Python results into Email Body. in Python Questions

How to display Python results into Email Body.

DevinUnderwood3 — Thu, 19 Sep 2019 16:16:47 GMT

I use from email.mime.text import MIMEText to use typed text into the email body.

How do I pass the python returned results into the body of an email?

Re: How to display Python results into Email Body.

Jeremy_Moore — Sun, 12 Dec 2021 03:15:01 GMT

Here is the reference for the python email package which also handles MIME:

19.1. email — An email and MIME handling package — Python 3.4.10 documentation

Here are some examples:

19.1.14. email: Examples — Python 3.4.10 documentation

Here is a working script example that I found on stackoverflow:

MIMEMultipart, MIMEText, MIMEBase, and payloads for sending email with file attachment in Python - Stack Overflow

In the code from stackoverflow, you would substitute the text for "body =" with any information from arcpy. For example if you wanted to know the feature count of a feature class or layer and you wanted to email your self the count. You would do something like what is below ( I have no idea if this works, I just quickly hacked it together). You will also need to learn how to use SMTP lib so you can connect, login and send emails. Take the code below and see if you can get it to send an email.

Have Fun!

import smtplib
import arcpy
from email.MIMEMultipart import MIMEMultipart
from email.MIMEText import MIMEText
from email.MIMEBase import MIMEBase
from email import encoders

lyrfile = r"C:\data\streets.lyr"
result = arcpy.GetCount_management(lyrfile)

fromaddr = "YOUR EMAIL"
toaddr = "EMAIL ADDRESS YOU SEND TO"

msg = MIMEMultipart()

msg['From'] = fromaddr
msg['To'] = toaddr
msg['Subject'] = "SUBJECT OF THE EMAIL"

body = '{} has {} records'.format(lyrfile, result[0])

msg.attach(MIMEText(body, 'plain'))

filename = "NAME OF THE FILE WITH ITS EXTENSION"
attachment = open("PATH OF THE FILE", "rb")

part = MIMEBase('application', 'octet-stream')
part.set_payload((attachment).read())
encoders.encode_base64(part)
part.add_header('Content-Disposition', "attachment; filename= %s" % filename)

msg.attach(part)

server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(fromaddr, "YOUR PASSWORD")
text = msg.as_string()
server.sendmail(fromaddr, toaddr, text)
server.quit()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: How to display Python results into Email Body.

DevinUnderwood3 — Thu, 19 Sep 2019 18:30:30 GMT

Thanks for your response, I have already successfully sent an email, but with just typed text.

I don't think your example will work since it refers to attachments which I don't want.

I tested this out and it does not work, I still receive a blank email body.

Re: How to display Python results into Email Body.

Jeremy_Moore — Thu, 19 Sep 2019 18:46:25 GMT

What kind of information are you trying to send in the email? Can you also share the code you are working with?

Re: How to display Python results into Email Body.

DevinUnderwood3 — Thu, 19 Sep 2019 20:12:37 GMT

import smtplib
from email.mime.text import MIMEText

arcpy.ListFiles()

# me is the sender's email address
# you is the recipient's email address

msg = MIMEText(text, 'plain')
msg['From'] = me
msg['To'] = you
msg['Subject'] = "Email"

# email body
text=' body'

# Send the message via SMTP server
s=smtplib.SMTP('smtp.escondido.org')
s.sendmail(me, [you], msg.as_string())
s.quit()

Re: How to display Python results into Email Body.

DevinUnderwood3 — Thu, 19 Sep 2019 20:15:02 GMT

I just want the returned list of files displayed in the body.

Re: How to display Python results into Email Body.

Jeremy_Moore — Sun, 12 Dec 2021 03:15:04 GMT

I edited your code a little bit, I saw some errors. Try this code below and let me know if it works. If it does then we can do some text formatting so it looks pretty.

import smtplib
import arcpy
from email.mime.text import MIMEText

arcpy.env.workspace = r"Enter Your Folder Path"
listFiles = arcpy.ListFiles()

# me is the sender's email address
# you is the recipient's email address
msg = MIMEText(text, 'plain')
msg['From'] = me
msg['To'] = you
msg['Subject'] = "Email"

# email body
text = listFiles

# Send the message via SMTP server
s = smtplib.SMTP('smtp.escondido.org')
s.sendmail(me, [you], msg.as_string())
s.quit()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: How to display Python results into Email Body.

DevinUnderwood3 — Tue, 24 Sep 2019 16:49:14 GMT

Thanks for your advice.

I just needed to included the email parameters into my list files loop function.

I am one step closer to success. I only get a result of the last item in the specified folder.

I need to modify how I am looping the folder and how it passes to the text to loop also.

Re: How to display Python results into Email Body.

DevinUnderwood3 — Tue, 24 Sep 2019 16:58:18 GMT

Update: I know receive separate emails for each listed file. Now, if can combine all of these emails into just one.

Re: How to display Python results into Email Body.

LeoLiu1 — Fri, 27 Sep 2019 07:44:56 GMT

Doesn't arcpy.ListFiles() return you all the files' names in your folder as a single string ?