Post reply

Sending Email automatically

  • August 15, 2005 at 5:16 am

    #67836

    Does anyone know how to send email automatically.

    I have records in a table that contains a date added. I want that when todays date is 10 days past the date added in the table that an email will be sent off to the person who added the record. The persons email address is also stored in the table along with the record they added.

    I know the code to use to send an email but what I don't know is how do you schedule the code to kick off to check the dates and to then send off the email.

    anyone any ideas?

    macca

  • August 15, 2005 at 6:06 am

    #582101

    Probably the easiest way is to create a job and have it scheduled daily to either A.  run a stored procedure with the code or B.  run a DTS package with the code...



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply