System extended stored procedures
982
... [, mail_password =
mail-password
]
... )
None.
xp_startmail is a system stored procedure that starts an e-mail session.
The mail-login-name and mail-password values are strings containing the
MAPI login name and password to be used in the mail session.
If you are using Microsoft Exchange, the mail_login_name argument is an
Exchange profile name, and you should not include a password in the
procedure call.
The xp_startmail system procedure issues one of the following return codes:
Return code Meaning
0 Success
2 Failure
xp_sendmail system procedure
To send an e-mail message.
[ [
variable
= ] CALL ] xp_sendmail (
... [ recipient =
mail-address
]
... [, subject =
subject
]
... [, cc_recipient =
mail-address
]
... [, bcc_recipient =
mail-address
]
... [, "message" =
message-body
]
... [, include_file =
file-name
]
... )
Must have executed xp_startmail to start an e-mail session.
xp_sendmail is a system stored procedure that sends an e-mail message once
a session has been started to
xp_startmail
.
The argument values are strings. The message parameter name requires
double quotes around it, because MESSAGE is a keyword.
The xp_sendmail system procedure issues one of the following return codes:
Permissions
Description
Return codes
Function
Syntax
Permissions
Description
Return codes