Aug-08-2020, 03:11 AM
Hello all
I was hoping someone could help me with the following coding problem.
I am trying to send an email where the body of the email is taken from a data frame, which i have managed to do.
However i want to start the email by saying Hi Name, where Name is a variable that contains the person's name to whom i am sending the email to - This is the bit i cannot get working.
The code i have so far is as follows:-
In this case the variable Name is Tom and i want to include Tom in the email.
Can anyone help?
Still a newbie; approx 3 weeks playing with Python (cut and past most of this code)
Any help will be greatly appericated.
Thank you.
I was hoping someone could help me with the following coding problem.
I am trying to send an email where the body of the email is taken from a data frame, which i have managed to do.
However i want to start the email by saying Hi Name, where Name is a variable that contains the person's name to whom i am sending the email to - This is the bit i cannot get working.
The code i have so far is as follows:-
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
import smtplibfrom email.mime.multipart import MIMEMultipartfrom email.mime.text import MIMEText mail=smtplib.SMTP('smtp.gmail.com', 123) mail.ehlo() mail.starttls() mail.login("Email","Pwd") From_Address = ["From_Email"]To_Address = [Report_Data_Frame.iloc[0,10]]CC_Address = ["CC_Email", "CC_Email", "CC_Email"]Subject_Email = "Email_Subject" Body = Email_Body_Data_FrameName = "Tom" html = """\<html> <head> Hi Name Goes HERE!!! <br> <br> TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT<br> <br> </head> <body> {0} </body> <br> TEXT TEXT <br><br> TEXT TEXT <br><br> TEXT TEXT <br><br> TEXT TEXT <br> </html> """.format(Body.to_html()) msg = MIMEMultipart()msg['From'] = ', '.join(From_Address)msg['To'] = ', '.join(To_Address)msg['Cc'] = ', '.join(CC_Address)msg['Subject'] = Subject_Email message = MIMEText(html,'html')msg.attach(message)mail.sendmail(From_Address, (To_Address + CC_Address), msg.as_string()) |
Can anyone help?
Still a newbie; approx 3 weeks playing with Python (cut and past most of this code)
Any help will be greatly appericated.
Thank you.