Auto mailing in PERL

[saravana]

We have a list of email ids stored in MYSql database.Depending upon the dates stored in the field,email should be sent to the corresponding email-ids automatically through PERL.
for eg.,
we have a table xyz with fields
date
email_id
message

if the date field contains today's date a mail should be generated to the corresponding email address with the coresponding message. This should be done only in PERL and the database associated is MySQL.

 

[MikeLacey]

Hi saravana,

Let's break this down then -- Three Tasks:

1 -- Getting data from the database.

2 -- Generating the email.

3 -- Sending the email.

Some questions:

a. What platform are you working on?

b. Are you already reading data from this database using Perl? If you are it would be easiest to use that method, otherwise have a look at

http://www.perl.com

and search for DBI. The DBI is a good method of working with databases but does need some work up-front to install.