This is my first post in this forum.
I am looking for a code to solve my case. I have a sheet with 500 Rows and about 20 columns

1 Column (Say Mail Id) has 50 unique values I need to create 50 sheets, where the sheet name can be the mail id itself, containing all the rows the mail Id is common.
After that I also want to send a mail to the mail Id those 10 recs (approx)

That is to say from 1 Sheet i need to create 50 sheets and 50 e-mail messages based on the mail Id that is one of the column in the original sheet. Any pointers...