How to: Set Up SQL Mail (SQL Server Management Studio)
This topic describes how to use SQL Server Management Studio to set a mail profile for SQL Mail. Before you can use SQL Mail, you must enable SQL Mail. SQL Mail can be enabled by opening the Properties dialog box from the SQL Mail node, by using the Surface Area Configuration facet of Policy-Based Management, or by using the sp_configure stored procedure.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
To set a mail profile for SQL Mail
In Object Explorer, expand a server.
Expand the Management folder.
Right-click SQL Mail and select Properties. If SQL Mail has not been enabled, you will receive a prompt to enable SQL Mail.
In the Profile name list, select the mail profile that you configured for SQL Mail. For more information on configuring a mail profile, see How to: Configure Mail Profiles for Use by SQL Mail (Windows).
You must have Microsoft Outlook installed on the computer that runs SQL Server to configure SQL Mail.