When I send an e-mail with attachement (a excel document) using python and smtplib, the document that is in attachement lose his extention and turn into a .bin file for no reason.
import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.base import MIMEBase
from email import encoders
Smail = "example@hotmail.com"
Smailpass = "password"
Rmail = "example@yahoo.com"
msg = MIMEMultipart()
msg['From'] = Smail
msg['To'] = Rmail
msg['Subject'] = "Subject of the Mail"
MailMSG = "this is a test py"
msg.attach(MIMEText(MailMSG, 'plain'))
# attach file
myfile = "document.xlsx"
attachment = open("custom directory/document.xlsx", "rb")
p = MIMEBase('application', 'octet-stream')
p.set_payload((attachment).read())
encoders.encode_base64(p)
p.add_header('Content-Decomposition', 'attachment, filename="document.xlsx"')
msg.attach(p)
# login and send
Mailserver = smtplib.SMTP("smtp.live.com", 587)
Mailserver.ehlo()
Mailserver.starttls()
Mailserver.login(Smail, Smailpass)
text = msg.as_string()
Mailserver.sendmail(Smail, Rmail, text)
Mailserver.quit()