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. Please note that summations are are done email is sent 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.