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:-
[python]
import smtplib
from email.mime.multipart import MIMEMultipart
from 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_Frame
Name = "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())
[/python]
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.
--
https://mail.python.org/mailman/listinfo/python-list
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:-
[python]
import smtplib
from email.mime.multipart import MIMEMultipart
from 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_Frame
Name = "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())
[/python]
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.
--
https://mail.python.org/mailman/listinfo/python-list