ASP Email Notification

[walebel]

I'll appreciate any assistance on this. The scenario;

I have a database table with the following sample records;

data1----------------dt2----data3------data4---------data5------data6
Brewing Plant-----2------10000------11/3/2012----1136-------person1@yahoo.com
Brewing Plant-----2------10000------11/3/2012----1136-------person1@yahoo.com
Car Plant-----------1------5000-------11/3/2012----568--------person1@yahoo.com
Brewing Plant-----1------5000-------11/3/2012----568--------person2@yahoo.com
Car Plant-----------4------20000------11/3/2012----2272-------person2@yahoo.com
Brewing Plant-----3------15000------11/3/2012----1704-------person3@yahoo.com

This is my requirement:
I want just one notification email each sent to theses various persons with their information, e.g;

Person1 should receive an email like
Data1--------------dt2----data5
Brewing Plant-----4------2272
Car Plant----------1------568

while Person2 should receive an email like
Data1------------dt2---data5
Brewing Plant----1-----568
Car Plant---------4-----2272
and so on.

I am using classic ASP and MySQL

Thanks for your anticipated assistance.