Question: Write a python script which will pull data from two excel files based on name column and send found information from those excel files to
Write a python script which will pull data from two excel files based on name column and send found information from those excel files to their emails whose name are present in name columns.
Table 1: Information Table
| Name | Type | Address | Project |
| Lee Song | Food | 1122 street | 12 Projects |
| Moon Lee | Song | 2345 Steet | 32 Projects |
| Sun Fun | Movies | 3456 Street | 23 Projects |
| Foon Lee | Clothes | 7894 Street | 20 Projects |
| Lee Song | Chinese | 5566 Street | 24 Projects |
| Moon Lee | Korea | 3352 Street | 90 Projects |
| Sun Fun | Restaurant | 0023 Street | 22 Projects |
| Foon Lee | Market | 1010 Street | 44 Projects |
Table 2: Email Information
| Name | |
| Lee Song | Firstname.lastname@email |
| Moon Lee | Firstname.lastname@email |
| Sun Fun | Firstname.lastname@email |
| Foon Lee | Firstname.lastname@email |
So output email will be like: Email :: Lee.Song@email.com
Hello Lee Song,
Here is the all projects you have :
| Name | Type | Address | Project |
| Lee Song | Food | 1122 street | 12 Projects |
| Lee Song | Chinese | 5566 Street | 24 Projects |
And thats how all the people will get email whose name is present in the name column.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
