Conditional Emailing

[pkohli88]

Hi,
I am pretty new to Perl. So I don't know whether it can be done or not. so your reponse will be really appreciated.

I have two tables 1) Changes & 2) Contact

Now In changes Table, i have couple of columns including old value & New value coloumns. In these two columns one contains Old value of Group and other contains New value of Group
for example

ID      Old Value             New Value
123     amer_tsscb            bime_tsscb
567     bime_tsscb            amer_tsscb
345     sign_tigaa            bime_tsscb
567     amer_tsscb            bime_tsscb

now 2) table called Contacts has list of all email id's that each group belongs

example

grp                   email
amer_tsscb            rick@de.com
amer_tsscb            jay@de.com
amer_tsscb            ram@de.com
bime_tsscb            ram@de.com
bime_tsscb            jhon@de.com
sign_tigaa            jay@de.com
sign_tigaa            rick@de.com
sign_tigaa            tom@de.com
sign_tigaa            todd@de.com

now i want to send emails to all users in each group if that group has value either in OLD Column or NEw Column of Change table.

Thanks

 

[1DMF]

is this a PERL question or SQL select question?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you.

 

[pkohli88]

Hi,
I will have report for each group and i want to send it to all users belong to that group.
is that can be done as a script?

Thanks

 

[1DMF]

what do you have so far, have you made a start? can you connect to the DB and select the data you require?

what environment are you in *nix or Windows, so can you use sendmail or do you need to use Net::SMTP;



"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you.