Sergio, xp_sendmail is the T-SQL proc to do this. Look it up in Books On-Line.
Before you can use SQLMail procs, SQLMail needs to be configured and started under Support Services in SQl Enterprise Manager. Before you go in there, create a MAPI profile under the user profile of the SQL Server Logon Account; in this profile, you set up an e-mail account for the Imail server (just put in a dummy POP3 name, since SMTP is your only requirement). You can test all this stuff under an interactive logon session as the user. Give it a shot; it does work and is quite cool. If you're not a SQL guy, though, it might take you a bit to come up to speed. Good luck, Sandy Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
