Python Forum

Full Version: Including a Variable In the HTML Tags When Sending An Email
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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:-

        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())
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.