OUT_EMAIL

OUT_EMAIL

The table OUT_EMAIL is the main table for the e-mail out service. Records inserted into this table will be sent out. The table contains the specifics of the outgoing email like subject, from, reply to and body.

Column Required (not Null) Type Values Comments
gKey Yes Uniqueidentifier gKey need to exist in EVENT_MASTER
jKey Yes Uniqueidentifier The jKey is used to link the OUT_EMAIL with OUT_EMAIL_RECEPIENT. See the database overview for more information.
ReplyTo Varchar(255) The E-mail account which will be suggested when recipient reply. If left blank (null) the default reply to value (see information on Admin Console) will be used. If default value is blank (null) the From field is used (see below).
Subject Yes Nvarchar (255) E-mail subject
Body Nvarchar (max) E-Mail body text. You may omit e-mail body in case you are using a reporting server report as provider of content. See the Attachment section under EVENT_CONTENT
“Msg_Id Varchar (255) Used internally by Boomerang to track e-mail reply’s
Key1 Yes Uniqueidentifier Used internally by Boomerang to track e-mail reply’s
Key2 Yes Uniqueidentifier Used internally by Boomerang to track e-mail reply’s
Key3 Yes Uniqueidentifier Used internally by Boomerang to track e-mail reply’s
Processed_On Datetime Updated by Boomerang indicating when e-mail message was sent.
IncludeKey Yes Integer 0 = No key to be included in message.
1 = Include key.
2 = Include key at end of message
Default 1. For more details on the incomming and responce tracking see IN_EMAIL
From Varchar(255) This is the display name and e-mail address that will be visible to the recipient(s) of the e-mail and should be formatted like this:

 “first name”<email@domain.com>

If left blank (null) the default From value (see information on Admin Console) will be used.

XPriority Integer 1 = Highest
2 = High
3 = Normal
4 = Low
5 = Lowest
E-mail priority settings.Default value is 3