By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,867 Members | 1,964 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,867 IT Pros & Developers. It's quick & easy.

ASP Email Notification

P: 1
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
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
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.
Nov 27 '12 #2

Post your reply

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