I have a master sheet (Sheet1) whose sample data is as below.
I have sheet 2 where below data is filled in it.
I want a macro where if i run it, data from sheet 1 (all data) of a user will be emailed to that specific user only.
EG: Data of John will be emailed to john123@gmail.com (data will consist 11 columns and 2 rows as John is repeated twice).
Hence john will get data from Sheet1 (11 columns & 2 rows) via email to his mail id.
After john, macro will then check the second row and email the available data of tony to his email ID.
Hence the loop will continue until there is data in col F.
Book1 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Call ID | Call Link | Category | Score | Score | Scoring Agent | Assessment | QA | Error Type | Revised | Comment | ||
2 | 7328001 | https:\\www.google.com | leaseterm | 6-12Month | Did Not Discuss | John | 10th August | Tina | S1 | Quality Correct | All Ok | ||
3 | 7328001 | https:\\www.google.com | leaseterm | 6-12Month | Did Not Discuss | Tony | 10th August | Tina | S2 | Quality Correct | All Ok | ||
4 | 7328001 | https:\\www.google.com | leaseterm | 6-12Month | Did Not Discuss | John | 10th August | Tina | S3 | Quality Correct | All Ok | ||
Sheet1 |
I have sheet 2 where below data is filled in it.
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Name | |||
2 | John | john123@gmail.com | ||
3 | Mack | mack123@gmail.com | ||
Sheet2 |
I want a macro where if i run it, data from sheet 1 (all data) of a user will be emailed to that specific user only.
EG: Data of John will be emailed to john123@gmail.com (data will consist 11 columns and 2 rows as John is repeated twice).
Hence john will get data from Sheet1 (11 columns & 2 rows) via email to his mail id.
After john, macro will then check the second row and email the available data of tony to his email ID.
Hence the loop will continue until there is data in col F.
Last edited by a moderator: