hi !
i have to send mail with link to the user who are all
registered. this process is completed and i stored the information in
sqlserver. but if the user didnt accept the link for three days from
the sent date then have to send a reminder message as a mail to the
user ! how to send the reminder message as a mail...? am working in
vb.net backend sqlserver 2005
if anyone have a idea of solving this pls give me some idea !!
the reply for this is
1. You will first need to setup SQL Server so that it can send emails. Search the web for some tutorials on how to do this.
2. The stored procedure to send emails is master..xp_send_mail.
3. Create a stored procedure that accesses your tables and, if the todays date is right, creates and sends the emails.
4. Finally create a Job that runs the stored procedure at t ...
Go to the complete details ...