Skip to content
    Birthday Wish Sender@carriebrammer
    .gitignore
    birthdays.csv
    main.py
    Packager files
    poetry.lock
    pyproject.toml
    Config files
    .replit
    replit.nix
    import datetime as dt
    import pandas as pd
    import smtplib
    import os
    import random

    # ----- Change birthday months, days and eails in
    # ----- 'birthdays.csv' to today's date and your email
    # ------to test that the program sends random birthday
    # ------wish to email contacts

    now = dt.datetime.now()
    month = now.month
    day = now.day
    my_email = 'carriepython@gmail.com'
    password = 'ysboclzidlnfsmys'
    dir = 'letter_templates'

    data = pd.read_csv('birthdays.csv')
    data_dict = data.to_dict(orient='records')

    for index in data_dict:
    if index['month'] == month and index['day'] == day:

    name = index['name']
    to_email = index['email']

    random_letter = random.choice(os.listdir("letter_templates"))
    with open(f"letter_templates/{random_letter}", 'r') as file:
    contents = file.read()
    body = contents.replace("[NAME]", f"{name}")

    with smtplib.SMTP('smtp.gmail.com', port=587) as connection:
    connection.starttls()

    connection.login(user=my_email, password=password)

    # send mail - from, to, and message
    connection.sendmail(from_addr=my_email,
    to_addrs=to_email,
    msg=f"Subject:Happy Birthday!\n\n{body}")