468,470 Members | 2,066 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,470 developers. It's quick & easy.

ASP Email Notification

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

I have a database table with the following sample records;

Expand|Select|Wrap|Line Numbers
  1. data1-------------dt2----data3------data4--------data5------data6
  2. Brewing Plant-----2------10000------11/3/2012----1136-------person1@yahoo.com
  3. Brewing Plant-----2------10000------11/3/2012----1136-------person1@yahoo.com
  4. Car Plant---------1------5000-------11/3/2012----568--------person1@yahoo.com
  5. Brewing Plant-----1------5000-------11/3/2012----568--------person2@yahoo.com
  6. Car Plant---------4------20000------11/3/2012----2272-------person2@yahoo.com
  7. 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
Expand|Select|Wrap|Line Numbers
  1. Data1------------dt2----data5
  2. Brewing Plant----4------2272
  3. Car Plant--------1------568
while Person2 should receive an email like
Expand|Select|Wrap|Line Numbers
  1. Data1------------dt2---data5
  2. Brewing Plant----1-----568
  3. Car Plant--------4-----2272
and so on.

I am using classic ASP and MySQL

Thanks for your anticipated assistance.
Nov 27 '12 #1
1 1597
5,400 Expert Mod 4TB
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.
Nov 27 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Rene Aguirre | last post: by
7 posts views Thread by Rob Meade | last post: by
1 post views Thread by rikerhill | last post: by
2 posts views Thread by =?Utf-8?B?eHl6X2phdA==?= | last post: by
1 post views Thread by kmladenovski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.