Emailing from sql server

[kss1133]

I have this table that has email addresses in it, based on a date value in the same table I want to be able to send an email to the address. I want this to run as a job. How can I make this possible, also I don't want to use MAPI and load outlook.

Thanks for any advice,
KSS

 

[SQLDenis]

Take a look at xp_SMTPSendMail
you can get it here

http://www.thorpesoftware.com/

but it's not free

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[mrdenny]

You can also look into xp_smtp_sendmail from

http://www.sqldev.net/xp/xpsmtp.htm

which is free and works great on SQL 7 / 2000 / 2005.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com