I have used the code from Send email from Databricks Notebook with attachment to attempt sending code from my Databricks Community edition:
I have used the following code:
import smtplib
from pathlib import Path
from email.mime.multipart import MIMEMultipart
from email.mime.base import MIMEBase
from email.mime.text import MIMEText
from email.utils import COMMASPACE, formatdate
from email import encoders
from_email = "myname@myemail.co.uk"
to_email = "myname@myemail.co.uk"
def send_mail(send_from = from_email, send_to = to_email, subject = "Test", message = "Test", files=["/FileStore/tables2/"],
server="smtp.hosts.co.uk", port=587, username='myusername.co.uk', password='!L3qGWGuyw',
use_tls=True):
msg = MIMEMultipart()
msg['From'] = send_from
msg['To'] = COMMASPACE.join(send_to)
msg['Date'] = formatdate(localtime=True)
msg['Subject'] = subject
msg.attach(MIMEText(message))
for path in files:
part = MIMEBase('application', "octet-stream")
with open(path, 'rb') as file:
part.set_payload(file.read())
encoders.encode_base64(part)
part.add_header('Content-Disposition',
'attachment; filename="{}"'.format(Path(path).name))
msg.attach(part)
smtp = smtplib.SMTP(server, port)
if use_tls:
smtp.starttls()
smtp.login(username, password)
smtp.sendmail(send_from, send_to, msg.as_string())
smtp.quit()
As you can see the code is almost identical. However, when I run the code I get the following error:
FileNotFoundError: [Errno 2] No such file or directory: '/FileStore/tables2/'
Is this error also because I'm running on Databricks Community edition, as was the case in the previous question.
