A Python script that reads tasks and deadlines from an Excel file and automatically sends email reminders.
- Reads tasks and deadlines from
deadlines.xlsx - Sends reminders if a deadline is within 2 days
- Supports multiple recipients (comma‑separated emails in Excel)
- Secure credential handling via
.envfile - Logs each run in
log.txt
Your deadlines.xlsx should have 3 columns:
| Task | Deadline | Recipient Email |
|---|---|---|
| Assignment | 2026-01-01 | user1@example.com, user2@example.com |
| Project Report | 2026-02-01 | user3@example.com, user4@example.com |
Create a .env file in the project root:
OUTLOOK_EMAIL=your_email@gmail.com OUTLOOK_PASSWORD=your_app_password_here SMTP_SERVER=smtp.gmail.com SMTP_PORT=587
- Install dependencies: pip install openpyxl python-dotenv
- Run the bot: python main.py
- Check your inbox for reminders!
- Never commit your real
.envfile to GitHub. - Add
.envto.gitignore. - Use
example.envwith placeholder values for sharing.