When vaccines were finally released during the COVID outbreak, pharmacies became very busy making appointments. This program automates that process by having the user input an excel file with names, email addresses, and first COVID appointment dates; having the user customize their email to be sent out, and automatically sending the email to each address with second COVID appointment dates.
- Leverage of Pandas for data manipulation, dateutil for date calculations, and Python’s built-in smtplib and email.message libraries for email sending
- Intuitive user instructions guide the process of uploading an Excel file with patient data, ensuring seamless data integration
- Extracts patient names, emails, and vaccination dates from the uploaded Excel sheet, and utilizes dateutil to calculate the corresponding second vaccine dates
- Dynamically creates personalized email content with appointment information, empowering healthcare professionals to communicate effectively
- Incorporates error handling to identify and handle invalid email addresses, guaranteeing the successful delivery of notifications
*Program implemented on Replit*
Create_Task_video.mp4
danidarf@DanisLaptop:~$ https://github.com/danielledarfour/COVID-Email-Automator.git- Open Folder in IDE and run
- Use "Test.xlsx" Excel file already uploaded
- When system prompts you to enter email address, use "local.pharmacy1234@gmail.com"
- When system prompts you to enter email password, use "localpharm"
- Log into provided gmail account to see results
MUST USE A GMAIL ACCOUNT
- Select Mail app and the device you're using
- Generate password and use that when system prompts you to enter email password
- Run program as usual
- Excel file must be formatted like this:
- Table must be on first sheet
- Start in Box A1
- Each column must have a heading and contain names in first column, emails in second, and dates in third (can use different heading names)
- Upload Excel file to cloned program folder
- Run program as usual