Sending Mail

Hi, help me
I have attached excel sheet, in this i need to send mail first 4 row need to send ‘suresh’ mail id
1st 2 row need to send “krsssuresh” mail id

how to do it
let me know if any suggestion

Suresh S

Use read range to datatable.
Create list of unique emailid using select.
query datatable using select with every unique emailid
pass the array of datarow as html table in email body or use write range in new excel, save file and send as attachment for each unique emailid