sending emails with in a table

[Guest_imported]

Placing a reminder date in a table. Once the date equals todays date an email is then sent out to the person who entered the request.

How is this done?
Does anybody now?

 

[tlbroadbent]

[li]Create a stored procedure to send the email.
[li]In the SP declare a cursor to select all records that are due a reminder message.
[li]Loop thru the cursor sending messages via xp_sendmail.[li]Optional: Update the table to indicate the message has been sent.
[li]Create a Job to execute the SP on a regular schedule - daily, every four hours, or whatever is needed. Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous