Have you ever faced the issue of sending emails to hundreds of people separately? Moreover, Emails with attachments and crucial information!
I guess absolutely yes!
Email Assistant is a project which is going to help you with everything. From sending emails to making certificate, everything is automated and the only thing needed is data.
After conducting a Machine learning event, I was having to send the certificate to the attendees.
The task was: Putting a name on the certificate template, Attaching it with the mail And sending it individually on each email id.
I know that this is going to be challenging for me, So I decided to make a project that goona do these things for me. And here is the resut : )
- It takes data from the csv file
- Take certificate template from the local folder
- Put the name and other details over it
- Save it to the local folder
- Takes email id from the CSV file
- Uses your email credentials
- Attach the certificate file of the person and send it over his/her mail id
- User friendly
- Time efficient
- And provide Graphical user Iterface
- Language: Python
- Libraries: Pandas,Numpy,Tkinter
- API: SMTPLIB
- Python 3.5 or above
- Import some Library
pip install tk
Installing Tkinter for Graphical user interface-
pip install pandas
Installing pandas for csv reading -
pip install numpy
Installing numpy for computational support
Run the project using python and then put the path of your csv file along with put the path of your certificate template. Moreover, email credentials are also needed so not forget to put it with.
Note
The mail must not be having two factor verification and have to allow the third party acess to google account.
You have to visit https://myaccount.google.com/lesssecureapps and click yes