New Microsoft Article: How to Send Email Without Using SQL Mail

Although SQL Mail lets you send and read email from SQL Server, you have to have a Messaging API (MAPI) subsystem on your server to use SQL Mail.

ITPro Today

April 10, 2002

2 Min Read
ITPro Today logo in a gray background | ITPro Today

Although SQL Mail lets you send and read email from SQL

Server, you have to have a Messaging API (MAPI) subsystem on your

server to use SQL Mail. Windows NT 4.0 installs a MAPI subsystem

when you install Windows Messaging, but Windows 2000 doesn't

provide a MAPI subsystem. So to use SQL Mail on Win2K, you must

install a MAPI client such as Microsoft Outlook.

 

However, you can send SMTP email directly from SQL Server by

using Collaboration Data Objects for NT Server (CDONTS) or CDO

for Win2K (CDOSYS) in combination with SQL Server's sp_OA OLE

Automation stored procedures. The new Microsoft article "HOW TO:

Send E-Mail Without Using SQL Mail in SQL Server" walks through

examples of how to use CDONTS and CDOSYS with the sp_OA

procedures to send email to an Internet mail server. http://support.microsoft.com/view/tn.asp?kb=312839

Read more about:

Microsoft
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like