https://stackoverflow.com/questions/67088891/send-email-from-databricks-notebook-with-attachment

i have to send the attachment to the organisation google drive folder directly instead of email any suggestions

sample email with attachement code

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()