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	Email
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	Email
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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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 Email 3345 MN Bob Bobby Bob.bobby@email.com 7382 NC...

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 Email 3345 MN Jessica Mara Jessica.mara@email.com 7382 NC...

Can you help me to write a python script which will create an excel file by combining two excel file I have two excel file Project File and State file. Project file : Project ID State 3345 MN 7382 NC...

Write a python script that will match two excel files based on the State column and those matched rows as a list , send to those responsible people who assign to that state through email as an...

Write a python script that will match two excel file based on State column and those matched rows as a list ,send to those responsible person who assign to that state through email as an attachment....

Write a python script that will pull data from Oracle SQL table and match it with an excel file and where name row match, send those rows to those people through email. Oracle SQL Table: Project...

Write a python script that will pull data from two excel files and send an outlook email with an attached file which is combined information of those two excel files. Excel File 1: Project...

Please write a python script that will filter an excel file on the "Name" column and send those filtered rows with a header to correspond email Excel File: Information Name Project ID Type Location...

Part 2 :: Sentiment Analysis Introduction Sentiment analysis is a computational technique used to determine the emotional tone behind words. It's crucial for understanding opinions in text, such as...

Estimate the time between each photoflash of the apple in Fig 2-18 (or number of photoflashes per second). Assume the apple is a bout 10cm in diameter.

Yesterday, Norton Corporations board of directors appointed Lucy Varden as the new president and chief executive officer. This morning, Ms. Varden presented to the board a list of her management team...

Which of the following statements is CORRECT? Group of answer choices If cash inflows from collections occur in equal daily amounts but most payments must be made on the 1 0 th of each month, then a...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

1. Workplace discrimination is an ongoing concern for organizations. HR departments should recognize the different individual characteristics and work processes that can lead to discrimination. They...

2. You recently learned that two of your key female employees will be taking maternity leave around the same time. What procedures or rules do you need to be aware of based on the Pregnancy...

2. Sexual harassment is not a new issue in organizations, but it is still an important one. Companies should develop policies that educate employees about sexual misconduct so that they act...