def _send_email_helper(settings, excel):
"""
Connects to SMTP email server and sends an email using the users credentials.
:return:
"""
try:
server = smtplib.SMTP(settings.smtp_server,
str(settings.smtp_port))
server.starttls()
server.login(settings.user, settings.password)
dest = [str(settings.user), str(settings.dest_addr)]
server.sendmail(settings.user, dest,
Email._set_email(settings, excel).as_string())
server.quit()
FileHelper.archive(settings, excel)
excel.clear_sheet()
excel.gen_dates()
Popups.email_sent()
except Exception:
print("Send email failed.")
