Question
Can you help me to write a python script which will send project lists to who is assign to that project. Excel file : Project
Can you 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 | Sana Khan | Sana.khan@email.com |
| 7382 | NC | Sana Khan | Sana.khan@email.com |
| 2504 | NC | Sana Khan | Sana.khan@email.com |
| 3335 | MN | Sana Khan | Sana.khan@email.com |
| 1234 | AZ | Sammy Ram | Sammy.ram@email.com |
| 3467 | AZ | Sammy Ram | Sammy.ram@email.com |
| 9087 | NC | Sana Khan | Sana.khan@email.com |
| 4573 | NY | Chand Hoq | Chand.hoq@email.com |
| 2590 | NY | Chand Hoq | Chand.hoq@email.com |
From this excel file , python script will send email to everyone with their project list. For instance, Sana Khan will get email and email will look like this :
Email address : sana.khan@email.com
Hello Jessica Mara,
Here is the project lists you have :
| Project ID | State | Name | |
| 3345 | MN | Sana Khan | Sana.khan@email.com |
| 7382 | NC | Sana Khan | Sana.khan@email.com |
| 2504 | NC | Sana Khan | Sana.khan@email.com |
| 3335 | MN | Sana Khan | Sana.khan@email.com |
| 9087 | NC | Sana Khan | Sana.khan@email.com |
Likewise, Sammy Ram will get his project list and Chand hoq 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Advances In Databases And Information Systems 23rd European Conference Adbis 2019 Bled Slovenia September 8 11 2019 Proceedings Lncs 11695
Authors: Tatjana Welzer ,Johann Eder ,Vili Podgorelec ,Aida Kamisalic Latific
1st Edition
3030287297, 978-3030287290
