Question: PYTHON : please help me to write a python script which will send project lists to who is assign to that project. Excel file :
PYTHON : please help me to write a python script which will send project lists to who is assign to that project.
Excel file :
| Project ID | State | Name | |
| 3345 | MN | Bob Bobby | Bob.bobby@email.com |
| 7382 | NC | Bob Bobby | Bob.bobby@email.com |
| 2504 | NC | Bob Bobby | Bob.bobby@email.com |
| 3335 | MN | Bob Bobby | Bob.bobby@email.com |
| 1234 | AZ | Sam Ramen | Sam.ramen@email.com |
| 3467 | AZ | Sam Ramen | Sam.ramen@email.com |
| 9087 | NC | Bob Bobby | Bob.bobby@email.com |
| 4573 | NY | Chin fin | Chin.fin@email.com |
| 2590 | NY | Chin fin | Chin.fin@email.com |
From this excel file , python script will send email to everyone with their project list. For instance, Bob Bobby will get email and email will look like this :
Email address : Bob.bobby@email.com
Hello Bob Bobby,
Here is the project lists you have :
| Project ID | State | Name | |
| 3345 | MN | Bob Bobby | Bob.bobby@email.com |
| 7382 | NC | Bob Bobby | Bob.bobby@email.com |
| 2504 | NC | Bob Bobby | Bob.bobby@email.com |
| 3335 | MN | Bob Bobby | Bob.bobby@email.com |
| 9087 | NC | Bob Bobby | Bob.bobby@email.com |
Likewise, Sam Ramen will get his project list and Chin Fin will get her projects list.
Please help me to write a python script which will send email to everyone with their project lists.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
