- You need to create a .py file that reads an excel sheet that has been attached to it using the
pandasmodule. 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 loopif you're sending it to multiple people - Address the
Sender,SubjectandTolocations - First Name of the
recieverwill be automatically picked using the line after the designation of theTolocation - Create the
HTMLtemmplate - Run the Program
