Hi,
In attached excel sheet, I want to create macro for data correction which will send mail to all user based on the email address through grouping in column F
that means for email (abc@lemonrice.com), all the below 5 records should enter in email template as below
Dear x,
Correct the data as per below table.
PID NAME HID GENDER OCCU EMAIL
101 ABC 23 M HW abc@lemonrice.com
101 ABC 25 M HW abc@lemonrice.com
101 ABC 35 M HW abc@lemonrice.com
101 ABC 38 M HW abc@lemonrice.com
101 ABC 41 M HW abc@lemonrice.com
--> On the next day, if the excel sheet contain exactly same record for particular user, it will send reminder mail that "correct the previous day record ASAP".
Thanks in advance
Bookmarks