main.py

import datetime as dt
import pandas
import random
import smtplib

MY_EMAIL = "mirela.manta23@gmail.com"  # testing email
MY_PASSWORD = "obqklcpwktzjrepz"

now = dt.datetime.now()
today_tuple = (now.month, now.day)
# print(today_tuple)

data = pandas.read_csv("birthdays.csv")
birthdays_dict = {(data_row.month, data_row.day): data_row for (index, data_row) in data.iterrows()}
# print(birthdays_dict)

if today_tuple in birthdays_dict:
    birthday_person = birthdays_dict[today_tuple]
    file_path = f"letter_templates/letter_{random.randint(1,3)}.txt"
    with open(file_path) as letters_file:
        contents = letters_file.read()
        contents = contents.replace("[NAME]", birthday_person["name"])

    with smtplib.SMTP("smtp.gmail.com") as connection:
        connection.starttls()
        connection.login(MY_EMAIL, MY_PASSWORD)
        connection.sendmail(
            from_addr=MY_EMAIL,
            to_addrs=birthday_person.email,
            msg=f"Subject:Happy Birthday\n\n{contents}"
        )