send email before an hour from apointment

sophia · September 13th, 2012, 12:56 PM

Hello Imar,

I thought a new feature in Appointment application. I want to let admin choose a time (in Hours and Minutes), so that a reminder email is sent to him before actual meeting.

For example if admin creates an appointment at 11AM and a reminder time set to 30 minutes then an email at 10:30 AM should be sent automatically to admin's email.

Please tell me how this can be done.

Thanks

Imar · September 13th, 2012, 01:52 PM

Hi Sophia,

I didn't write this chapter, so I can't help you. I am not sure, but I don't think the other authors follow this forum anymore.

The same applies to your message about the Chat application.

Cheers,

Imar

sophia · September 15th, 2012, 02:14 AM

OK I See!

But can you please give me a general idea about how we can send a reminder message on a preset time automatically in any application.

Many thanks...

Imar · September 15th, 2012, 04:54 AM

You could create a command line tool that checks the database and sends out e-mails. You can then schedule this tool using Windows Scheduler. You could also write a windows service, although that might be overkill.

Alternatively, search the web for asp.net scheduler to see some commercial components that can do this from within your asp.net application.

Cheers,

Imar

sophia · September 16th, 2012, 01:12 AM

Hi Imar, yes I also googled and I found windows service one of the solutions but I also came to knew that it needs dedicated hosting, on shared hosting it might not work.

Any other method like triggers on anything else?

Thanks

Imar · September 17th, 2012, 04:07 PM

Isn't that in my previous reply already?

Imar