- You need to create a .py file that reads an excel sheet that has been attached to it using the
pandas
module. A file that looks like this
Everything in the file has been commented for its positioning. Use that for better explanation
- Then assign variables to each column after reading it.
- Create a
for loop
if you're sending it to multiple people - Address the
Sender
,Subject
andTo
locations - First Name of the
reciever
will be automatically picked using the line after the designation of theTo
location - Create the
HTML
temmplate - Run the Program