How to send e-mail (Exchange) without using SQL Mail in SQL Server

There's an article on Microsoft's website to explain how to do it.

http://support.microsoft.com/kb/312839


I used CDOSYS because it doesn't need Outlook installation.

To use your company's Exchange Server, you need to assign value to more Configuration fields, which includes:

sendusing
smtpserver
smtpauthenticate
smtpserverport
smtpconnectiontimeout
sendusername
sendpassword
sendemailaddress
senduserreplyemailaddress.