# import smtplib
# from email.mime.text import MIMEText
# from email.mime.image import MIMEImage
# from email.mime.multipart import MIMEMultipart
# from python_postgres import get_data_insurance
# from datetime import datetime
# # Set up email message
# sender_email = 'scott_wright@currently.com'
# bcc_email = ''
# # Set up SMTP server connection
# smtp_server = 'smtp.mail.att.net'
# smtp_port = 587
# smtp_username = 'scott_wright@currently.com'
# smtp_password = 'jwbtbbqqwdkocrno'
# smtp_connection = smtplib.SMTP(smtp_server, smtp_port)
# smtp_connection.starttls()
# smtp_connection.login(smtp_username, smtp_password)
# data=get_data_insurance()
# for item in data:
# receiver_email = item[3]
# name = item[2]
# date = item[1]
# today = datetime.today()
# todays_formatted_date = today.strftime("%m/%d").replace("0", "", 1).replace("/0", "/")
# #print(todays_formatted_date)
# #print(date)
# if date == todays_formatted_date:
# #Add the text content of the email
# message_template =f'''
#
# {name},
# This will be the insurance agent email.
# Regards,
# Scott Wright
# Vice President, Commercial Lending
# swright@homestbk.com or scott_wright@currently.com
# Home State Bank
# Crystal Lake, IL
# 815-788-3475 office | 847-532-3886 cell/text
# 
# NOTICE: This electronic mail message and any files transmitted
# with it are intended exclusively for the individual or entity to
# which it is addressed. The message, together with any attachment, may
# contain confidential and/or privileged information. Any unauthorized
# review, use, printing, saving, copying, disclosure or distribution is strictly prohibited.
# If you have received this message in error, please immediately advise the sender by
# reply email and delete all copies.
#
# '''
# # create a message object and set its content
# msg = MIMEMultipart()
# msg['Subject'] = 'Request for Updated Insurance'
# msg['From'] = sender_email
# msg['To'] = receiver_email
# msg['Bcc'] = bcc_email
# # attach the HTML message to the message object
# html_part = MIMEText(message_template, 'html')
# msg.attach(html_part)
# # read the image file and attach it to the message object as an inline image
# with open('hsb_logo.png', 'rb') as fp:
# image_part = MIMEImage(fp.read())
# image_part.add_header('Content-ID', '')
# msg.attach(image_part)
# # Send email
# try:
# smtp_connection.sendmail(sender_email, [receiver_email, bcc_email],msg.as_string())
# print(f'Email sent successfully! to {name}')
# continue
# except Exception as e:
# print(f"An error occurred while sending email to {name}: {e}")
# continue
# else:
# continue
# smtp_connection.quit()