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

Email

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

Email

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

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!