I need to send 1 email to each user appearing multiple times in the excel with the row data. Can someone help with a vb script?
Below is my excel sheet
user@email.com should get an email like below with some text message
user1@email.com should get email as below with some text message
Below is my excel sheet
fullname | Data | Date | Duration | Usage | |
user@email.com | Name1 | Sample | 4/23/2021 1:45 | 10 days 22 hours 02 mins 55 secs | 100 |
user@email.com | Name1 | Sample1 | 4/23/2021 21:01 | 10 days 22 hours 02 mins 55 secs | 50 |
user1@email.com | Name2 | Sample2 | 4/24/2021 21:01 | 11 days 22 hours 02 mins 55 secs | 51 |
user1@email.com | Name3 | Sample3 | 4/25/2021 21:01 | 12 days 22 hours 02 mins 55 secs | 52 |
user1@email.com | Name4 | Sample3 | 4/26/2021 21:01 | 13 days 22 hours 02 mins 55 secs | 53 |
user@email.com should get an email like below with some text message
fullname | Data | Date | Duration | Usage | |
user@email.com | Name1 | Sample | 4/23/2021 1:45 | 10 days 22 hours 02 mins 55 secs | 100 |
user@email.com | Name1 | Sample1 | 4/23/2021 21:01 | 10 days 22 hours 02 mins 55 secs | 50 |
user1@email.com should get email as below with some text message
fullname | Data | Date | Duration | Usage | |
user1@email.com | Name2 | Sample2 | 4/24/2021 21:01 | 11 days 22 hours 02 mins 55 secs | 51 |
user1@email.com | Name3 | Sample3 | 4/25/2021 21:01 | 12 days 22 hours 02 mins 55 secs | 52 |
user1@email.com | Name4 | Sample3 | 4/26/2021 21:01 | 13 days 22 hours 02 mins 55 secs | 53 |