Project Brief
Your task for this project is to use Python to send an email to multiple email addresses found in an Excel file.
Step by Step Instructions
Download this Excel file. The Excel file looks like this:
Alternative download link:
Write a Python script that loads the Excel file and sends the following text to all the email addresses of the “Email” column:
”Hello all!
The party will take place this Saturday instead of Sunday.
See you there!"and the email subject should be “Change of party date“
Environment Setup Instructions
Install pandas and openpyxl:
pip install pandas openpyxl
You can use your Gmail address as the sender. You can create an app password here and then use that password in the Python script. Make sure you have turned on Gmail 2-step verification first.
Resources
Learn how to load Excel files with Python here:
https://pythonhow.com/how/add-a-new-column-to-an-excel-file/
Learn how to send an email with Python in “Python Mega Course” in this lecture:
https://www.udemy.com/course/the-python-mega-course/learn/lecture/34604178
The link to 2-step verification (https://myaccount.google.com/signinoptions/twosv) resulted in a 404 error. However, I did check in my account and had 2-factor verification turned on.