Mail Scheduler

[shaileshkumar]

Hi,
I have to design a mail scheduler which sends monthly news letters to all the regiastered users of my website.

Features of scheduler
----------------------------
picks up the email ids of registered users and sends mails.

This scheduler will do this job for every hour or so.

My doubts
------------
How to prevent the scheduler from sending the same mail to the same user more than once.

How can we send different mails to the same user on the same day.


My question is not about sending mails.It is about avoiding duplicate emails.

Thanks in Advance,
shailesh

[chaarmann]

Hi,
I have to design a mail scheduler which sends monthly news letters to all the regiastered users of my website.

Features of scheduler
----------------------------
picks up the email ids of registered users and sends mails.

This scheduler will do this job for every hour or so.

My doubts
------------
How to prevent the scheduler from sending the same mail to the same user more than once.

How can we send different mails to the same user on the same day.


My question is not about sending mails.It is about avoiding duplicate emails.

Thanks in Advance,
shailesh

Answer 1: every time a mail is sent successfully, let the scheduler toggle the status of the mail from "not sent" to "sent". So if the scheduler runs again, it skips all the emails with status "sent" and no email is sent twice.

Answer 2: Just give all new mails the status "not sent". So if there is a second mail for the same user on the same day, it just gets sent, too. Run the scheduler to check for unsent mails every hour a day.

[shaileshkumar]

Thanks,
I will update you when it is finished.

regards,
shailesh

[N002213F]

assuming persisted object NewsLetter and User, created another other object SentNewsLetter with NewsLetterID and UserID properties.

The NewsLetter object must mave a status isPublished that flag indicates that its ready to be sent. SentNewsLetters will have NewsLetterID and UserID.

After every email has been sent, create a SentNewsLetters object with the NewsLetterID and UserID it was sent to, and persist.

Before your scheduler runs it checks for each published newsletter, which users haven't received it, and sends to those.