How to copy data as per particular name and send it to him via mail?

[naveen4pundir]

I have sheet in which i have some customer details for telecalling for different telecallers. Now i want send these customer details as per telecaller .
for example i allocated 2 customers (63, 16) to Smith for telecalling. i want these customer details copy into new sheet and send new sheet to smith as attachment. i want this operation for ever telcaller. or if i want to send main sheet to all telecallers in a single mail.

sample data is attach.