Description:

• This simple but powerful code uses win32.client library for sending Outlook emails configured on your machine and openpyxl to read email id from excel sheet and send email to the destination.

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. You can provide emails to excel sheet it will automatically process the email id from there and send email to those email id. 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!