Skip to content

Getting the excel file through GUI, then searching for the specific keyword and mailing to the respective email address. Automated by python.

Notifications You must be signed in to change notification settings

pranavarora1895/Excel_Email_Automation

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Excel_Email_Automation forthebadge Microsoft Excel Gmail

Getting the excel file through GUI, then searching for the specific keyword and mailing to the respective email address. Automated by python.

To run the software, simply double click on the AutomateEmail.exe.

Installing Dependencies:

  • Open Terminal/CMD
  • Open Terminal or CMD, then Type pip install -r <path to the software requirements.txt> Example: pip install -r c://Users/Downloads/Excel_Email_Automation/requirements.txt

Important Steps to Setup Email Automation:

  • Goto Google Less Secure Apps and toggle the Less Secure Apps to allow python to send the emails for you.
  • Setup your email address and password as your environment variables to maintain your privacy.
  • In your Excel File, make sure that the heading of column 'email' is in lowercase ('email').
  • Make a Mail Body in notepad before running the software. It will ask for mail body during the execution.

Dont Delete Any Files.. IT MAY CRASH THE SOFTWARE!

Start The Software Using AutomateEmail.exe File!

NOTE -

ThankYou!

About

Getting the excel file through GUI, then searching for the specific keyword and mailing to the respective email address. Automated by python.

Resources

Stars

Watchers

Forks

Releases

No releases published

Sponsor this project

Packages

No packages published