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	Jessica Mara	Jessica.mara@email.com
7382	NC	Jessica Mara	Jessica.mara@email.com
2504	NC	Jessica Mara	Jessica.mara@email.com
3335	MN	Jessica Mara	Jessica.mara@email.com
1234	AZ	Schmid Cassie	Schmid.cassie@email.com
3467	AZ	Schmid Cassie	Schmid.cassie@email.com
9087	NC	Jessica Mara	Jessica.mara@email.com
4573	NY	Chad Hager	Chad.hager@email.com
2590	NY	Chad Hager	Chad.hager@email.com

From this excel file , python script will send email to everyone with their project list. For instance, Jessica Mara will get email and email will look like this :

Email address : Jessica.mara@email.com

Hello Jessica Mara,

Here is the project lists you have :

Project ID	State	Name	Email
3345	MN	Jessica Mara	Jessica.mara@email.com
7382	NC	Jessica Mara	Jessica.mara@email.com
2504	NC	Jessica Mara	Jessica.mara@email.com
3335	MN	Jessica Mara	Jessica.mara@email.com
9087	NC	Jessica Mara	Jessica.mara@email.com

Likewise, Chad Hager will get his project list and Schmid Cassie will get her projects list.

Please help me to write a python script that will send emails 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 Sana Khan Sana.khan@email.com 7382 NC Sana...

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

The adjusted trial balance of Sang Company shows the following data pertaining to sales at the end of its fiscal year October 31, 2017: Sales Revenue $820,000, Freight-Out $16,000, Sales Returns and...

Using the following balance sheet and income statement data, what is the debt to assets ratio? Current assets $22400 Net income $44500 Stockholders' Current liabilities 13400 66400 equity Average...

is Course: AcC 4 0 3 - 0 0 2 - 5 pring 2 0 2 5 : Advanced Account. Chapter 1 5 Homework Assign - ( 1 ) Soved Help Save 8 Exit Submit 2 Problem 1 5 - 2 5 ( Algo ) ( LO 1 5 - 4 ) 2 0 points The...

4. (8) The proton NMR shown was obtained from one of the compounds A-D. Proton integration numerical values are provided directly over the corresponding peaks. HO OH 2 2 1 OH OH D TMS A B C 1 0 4 11...

In an Excel Pivot Table, how is a Fact/Measure Column repeated?

In Gender Pay Equity Studies in the Federal Service, how can comparisons be ensured across Job of Comparable Worth?

In the Federal Evaluation System (FES), what standards are used in the Job Evaluation Process?