Automating email reports

[odysseyphotography]

A friend would like to have a signup form on his site. Anyone that
signs up will be entered into a database and automatically sent an
email report. This much I can do!

However, he'd then like the person to recieve a further 2 reports with
a specified delay (say a week) between each email. He'd like this
process to be automated - sending anyone who signs up the three reports
with a week between each emailing.

Any ideas on how this is achieved much appreciated! A script on the
server?

Many thanks,

OP

[Rik]

On Wed, 24 Jan 2007 18:40:59 +0100, odysseyphotography
<in**@odysseyphotography.netwrote:

A friend would like to have a signup form on his site. Anyone that
signs up will be entered into a database and automatically sent an
email report. This much I can do!

However, he'd then like the person to recieve a further 2 reports with
a specified delay (say a week) between each email. He'd like this
process to be automated - sending anyone who signs up the three reports
with a week between each emailing.

Any ideas on how this is achieved much appreciated! A script on the
server?

Indeed, run a cronjob, which checks what emails to sent, and does the
sending.

--
Rik Wasmus
* I'm testing several new newsreaders at the moment. Please excuse
possible errors and weird content. *

[Jerry Stuckle]

odysseyphotography wrote:

A friend would like to have a signup form on his site. Anyone that
signs up will be entered into a database and automatically sent an
email report. This much I can do!

However, he'd then like the person to recieve a further 2 reports with
a specified delay (say a week) between each email. He'd like this
process to be automated - sending anyone who signs up the three reports
with a week between each emailing.

Any ideas on how this is achieved much appreciated! A script on the
server?

Many thanks,

OP

I'd set up a cron job to run once a day. Have it scan the database and
based on whatever criteria you select send the email.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Tim Van Wassenhove]

odysseyphotography schreef:

However, he'd then like the person to recieve a further 2 reports with
a specified delay (say a week) between each email. He'd like this
process to be automated - sending anyone who signs up the three reports
with a week between each emailing.

As already mentionned, read the cron manual

Any ideas on how this is achieved much appreciated! A script on the
server?

Using http://www.swiftmailer.org/ you can reduce your work...

--
Tim Van Wassenhove <url:http://www.timvw.be/>

[Colin McKinnon]

Tim Van Wassenhove wrote:

odysseyphotography schreef:

>However, he'd then like the person to recieve a further 2 reports with
a specified delay (say a week) between each email. He'd like this
process to be automated - sending anyone who signs up the three reports
with a week between each emailing.

As already mentionned, read the cron manual

Really, at a trivial level 'at' is much more apposite however with smart
batch handling, cron might be easier.

Also you need to authenticate requests through the email address - usually
this is done by emailing back a response to a prompt. For that you will
need a mailbox with procmail setup in front of it or a cron job polling the
mailbox.

C.

[Rik]

On Wed, 24 Jan 2007 23:40:23 +0100, Colin McKinnon
<co**********************@ntlworld.deletemeunlessU RaBot.comwrote:

Tim Van Wassenhove wrote:

>odysseyphotography schreef:

>>However, he'd then like the person to recieve a further 2 reports with
a specified delay (say a week) between each email. He'd like this
process to be automated - sending anyone who signs up the three reports
with a week between each emailing.

As already mentionned, read the cron manual

Really, at a trivial level 'at' is much more apposite however with smart
batch handling, cron might be easier.

Also you need to authenticate requests through the email address -
usually
this is done by emailing back a response to a prompt. For that you will
need a mailbox with procmail setup in front of it or a cron job polling
the
mailbox.

Why doesn't a single email with a 'click on this link to confirm', and a
flag in database suffice? This setup seems a little overly complicated.

--
Rik Wasmus
* I'm testing several new newsreaders at the moment. Please excuse
possible errors and weird content. *

[odysseyphotography]

Thank you all so much.

OP

[odysseyphotography]

For anyone who can't set up a CRON job, and justs needs a quick and
easy solution - this might work:

<img src="http://www.urlhere.com/script.php" alt="script" width="1"
height="1" border="0" />