sp_Add_Email_List adds a comma (or semicolon) separated string of e-mail addresses in a single call.
Remarks
This procedure may be called at the time when an e-mail job is being created. It will insert multiple entries found on the input string into OUT_EMAIL_RECIPIENT table. Any white space between list separators will be trimmed.
Syntax
exec sp_Add_Email_List @jKey=... , @list=... , @type=... |
Parameters
| Column | Data Type | Direction | Description | Default | Status |
| @jKey | uniqueidentifier | in | jKey found in OUT_EMAIL table | Required | |
| @list | varchar(8000) | in | comma (or semicolon) separated string of SMTP e-mail addresses | Required | |
| @type | int | in | address type (1 = TO, 2 = CC, 3 = BCC) | 1 | Optional |
Return Code Values
0 (success) or non-zero (failure)
Examples
To add 3 recipients to a given e-mail job in one step.
/* .... some code ... */ EXEC sp_Add_Email_List @jKey, 'user1@hotmail.com; user2@msn.com; user3@gmail.com' /* .... some code ... */ |