import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.mime.base import MIMEBase
from email import encoders

email_user = 'emmanuel@nelaapp.com' # Gmail Login
email_password = 'PASSWORD'			# Gmail Password
email_send = 'emanfazio@gmail.com'	# Email of recepient

subject = 'Daily query results'		# Email Subject

msg = MIMEMultipart()
msg['From'] = email_user
msg['To'] = email_send
msg['Subject'] = subject

body = 'This email has been sent from Python!'	# Message with the email
msg.attach(MIMEText(body,'plain'))

filename ='api_customer_query.csv' # Attaching file saved in same folder as script
attachment = open(filename,'rb')

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

msg.attach(part)
text = msg.as_string()
server = smtplib.SMTP('smtp.gmail.com',587)
server.starttls()
server.login(email_user,email_password)


server.sendmail(email_user,email_send,text)
server.quit()

print('Email has been sent')