sp_Add_Email_List

sp_Add_Email_List

sp_Add_Email_Listadds 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 ... */

See Also

Helpers
Database Tables
Getting Started