Including a Variable In the HTML Tags When Sending An Email

Sat Aug 8 10:29:18 EDT 2020

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.