Send emails from SQL server without outlook

Posted on 2005-05-16
Medium Priority
Last Modified: 2008-07-24
Is there another way to send emails from SQL 2000 server other then installing outlook ?
 I just did a clean install of my server and dont feel like installing outlook unless it is my only option.



Question by:cmdias
LVL 18

Expert Comment

ID: 14014191
Hi cmdias,
From the Transact SQL Help file (search on MAPI), you can send mail by calling some system stored procedures... however, the machine does need to be set up with some sort of MAPI mail client software (doesn't have to be outlook... any MAPI complient e-mail package will do)


The computer running SQL Server must be set up as an e-mail client. SQL Server Enterprise Manager is used to assign an e-mail account and password to the SQL Server installation. The mail component of SQL Server can then be enabled to start automatically when the SQL Server Agent service is started. Alternatively, the mail component can be started and stopped at will using either SQL Server Enterprise Manager, or the xp_startmail, xp_stopmail, and xp_sendmail stored procedures.

When the mail component of SQL Server is running, it can be used to:

Send e-mail from Transact-SQL batches, scripts, stored procedures, and triggers using xp_send_mail. The e-mail can be:
Message strings.

The result set of a query.

A Transact-SQL statement or batch to execute.

A page for an electronic pager.
Read e-mail using sp_processmail, or a combination of xp_findnextmessage, xp_readmail, and xp_deletemail. The messages sent to SQL Server typically contain a Transact-SQL statement or batch to be executed. The statement is executed and the result set is returned as a reply e-mail with an optional CC: list.
SQL Server events and alerts can be combined with SQL Mail functionality to build a system in which a server running SQL Server can e-mail or page the relevant administrators automatically if serious conditions arise.

LVL 11

Accepted Solution

andrewbleakley earned 1000 total points
ID: 14014797
Use xpSMTP which you can get from http://www.sqldev.net/xp/xpsmtp.htm

It works fantastically and allows HTML messages etc etc.

Easy to get running and runs great

Expert Comment

ID: 14016869
u can use outlook programming through COM object as supported by SQL Server
with outlook's com object, u can manipulate messages, attachment etc etc...
im sure the free outlook express will also include the com object

search for "outlook com programming" or something

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question