Description:
- This simple but powerful code uses win32.client library for sending Outlook emails configured on your machine.
Pre-requisites:
- Have MS Outlook installed, configured and open.
- Python installed on your laptop
- Python path added to Environment variables.(Usually automatically added when installing python)
Steps:
- Clone the repository to your local machine.
- Install the requirements using pip install -r requirements.txt
- Navigate to the project folder on your terminal .\cd Outlook
- Open Timesheet_reminder_outlook.py and add desired email list in line number 17 of the script(list_of_emails).
- Run the CODE!!! using below command on your terminal
- python Timesheet_reminder_outlook.py
This is the output of this code
NOTE:
- This code sends out an email each time the code is run. However, if you want an automatic schdeuler to send the reminder email on a desired day and time, use the following steps.
Using Windows Task Scheduler to automatically send the reminder email every Friday at 9:30 AM
- Follow the steps as illustrated in the screenshots for Automatic scheduling(running the code every friday at 9:30 am)
- Open Windows Task Scheduler App. (Press Windows button > Search for 'Task Sceduler App' and follow along with the screenshots
Make sure to edit the list of emails in the script for the magic to happen! EDIT: Now the code is edited to fetch emails from your local excel sheet!
CAUTION: Don't Spam the actual email receiver. Test it if you need to, using your own emails Ids :)
https://github.com/rplatotech/AutoEmailReminder - FORK this repo and you are welcome to contribute!!
Feel free to contact me if you need help setting up!