InsertEmail (view)
The InsertEmail view is used to quickly and easily schedule new email messages for sending.
For example:
INSERT INTO InsertEmail (StatusID, ToAddress, BodyPlainText)
VALUES (N'SCHEDULED', N'alert@yourcompany.com', N'Test alert message')
This sends an email message to alert@yourcompany.com using the first available SMTP channel.
Find out more about how to use these Insert tables here.
The table below gives an overview of all properties that are available to set or select:
| Field | Type | Description |
| ID | int | Message ID |
| DirectionID | nvarchar(32) | Message direction |
| TypeID | nvarchar(32) | SMS, EMAIL, FILE or SMPPSERVERBIND |
| StatusID | nvarchar(32) | Message status |
| StatusDetailsID | int | User field |
| TriggerStatusID | nvarchar(32) | Trigger status |
| TriggerDetailsID | int | User field |
| AckStatusID | nvarchar(32) | Acknowledge status |
| ChannelID | nvarchar(32) | Channel ID of the channel that sent or received the message |
| BillingID | nvarchar(255) | Billing ID used for accounting |
| ScheduledTime | datetime2 | Time when the message is scheduled to be sent |
| SentTime | datetime2 | Time when the message was sent |
| ReceivedTime | datetime2 | Time when the message was received |
| LastUpdate | datetime2 | Time when the message record was last updated |
| Priority | int | Message priority |
| BatchID | int | User field |
| ConversationID | int | User field |
| Hash | nvarchar(100) | Hash of the message used by some channels |
| Creator | nvarchar(32) | Creator of the message |
| Archive | bit | System field |
| CustomField1 | int | User field |
| CustomField2 | nvarchar(255) | User field |
| Trace | nvarchar(max) | Trace information for the message |
| ImapUID | int | IMAP unique ID |
| Pop3ID | int | POP3 mailbox ID |
| EmailPriority | int | Email priority |
| Organization | nvarchar(255) | Name of the organization |
| ReadReceiptAddress | nvarchar(255) | Address used for read receipts |
| FromName | nvarchar(255) | Sender name |
| ReplyAddress | nvarchar(255) | Reply address |
| Subject | nvarchar(255) | Email subject |
| ToAddress | nvarchar(max) | Primary recipient |
| FromAddress | nvarchar(max) | Sender email address |
| CcAddress | nvarchar(max) | Carbon copy recipients |
| BccAddress | nvarchar(max) | Blind carbon copy recipients |
| BodyPlainText | nvarchar(max) | Plain text email body |
| BodyHtml | nvarchar(max) | HTML email body |
| Header | nvarchar(max) | Email headers |