InsertEmail (view)
The InsertEmail view is used to quickly and easily schedule new e-mail messages for sending.
For example:
INSERT INTO InsertEmail (StatusID, ToAddress, BodyPlainText)
VALUES (N'SCHEDULED', N'alert@yourcompany.com', N'Test alert message')
This will send out an e-mail message to alert@yourcompany.com to the first SMTP channel available.
Find out more on how to use these ‘Insert’ tables here.
The table below is an overview of all properties that are available to set or to 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/received the message |
| BillingID | nvarchar(255) | Billing ID used for accounting |
| ScheduledTime | datetime2 | When to send the message |
| SentTime | datetime2 | When the message was sent |
| ReceivedTime | datetime2 | When the message was received |
| LastUpdate | datetime2 | When the message record was last updated |
| Priority | int | The message priority |
| BatchID | int | User field |
| ConversationID | int | User field |
| Hash | nvarchar(100) | The hash of the message; used by some channels |
| Creator | nvarchar(32) | The creator of the message |
| Archive | bit | System field |
| CustomField1 | int | User field |
| CustomField2 | nvarchar(255) | User field |
| Trace | nvarchar(max) | A trace of the current message |
| ImapUID | int | IMAP Unique ID |
| Pop3ID | int | POP3 Mailbox ID |
| EmailPriority | int | E-mail priority |
| Organization | nvarchar(255) | Name of the organization |
| ReadReceiptAddress | nvarchar(255) | Address to send a read receipt to |
| FromName | nvarchar(255) | From name |
| ReplyAddress | nvarchar(255) | Reply address |
| Subject | nvarchar(255) | E-mail subject |
| ToAddress | nvarchar(max) | To address or primary recipient |
| FromAddress | nvarchar(max) | From address or originator of this e-mail |
| CcAddress | nvarchar(max) | Carbon Copy. Addresses that should receive a copy |
| BccAddress | nvarchar(max) | Blind Carbon Copy. Addresses that should receive a blind copy |
| BodyPlainText | nvarchar(max) | Plain text body |
| BodyHtml | nvarchar(max) | HTML formatted body |
| Header | nvarchar(max) | E-mail headers |