Reminder email

[sweetneel]

hi all,
thanx in advance. i need a help, its urgent. actually, i have developed a website. for contact information. there is a page for storing followup details of client. now i want that. the every client should get a automatic email , 2 days before their Followup date.

N.B. the databse is in ACCESS. socan't use sql server, and they can't permit to install Windows service there .

now any one can help me. how should i do this.
its urgent.

[Frinavale]

Well, you need to create a table to store the email address and the date for each person.

You'll have to develop an application (a service) that runs every day and sends emails to everyone that needs a reminder that day.

Or, if it's done manually by someone, then you can implement an asp.net application where a user can click a button and it sends the emails....


What have you done so far?

[flexteacher]

Setting up your server sql server do you want?

[maliksleo]

there are different ways to do this mostly two are used one is manually and other is automatic.
I will preffer manual because you will be able to send to selected ones or all or none what ever you want. Which is very simple as mentioned by Frinny all emails in one table and all that.

If you want to send emails automatically then write your code for email sending on the page which have to open very frequently. But the problem is that when that page will be re-opened then the emails will resend to all. This can be stopped by many ways e.g passing a value to database and place checks for it But its not a good idea for reminders. I will suggest you to use manual one.

maliksleo