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/[e-mail]
Brewing Plant-----2------10000------11/3/[e-mail]
Car Plant---------1------5000-------11/3/[e-mail]
Brewing Plant-----1------5000-------11/3/[e-mail]
Car Plant---------4------20000------11/3/[e-mail]
Brewing Plant-----3------15000------11/3/[e-mail]

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.

[zmbd]

walebel:
Please provide the code you've already attempted to accomplish this task and some more detail as to what your operating environment is and target email client.

You will also find some ideas in the MySQL and Access-VBA Bytes-forums as to how to setup the query.