SentItems

Archives sent email messages for auditing and retrieval. It allows querying and management of previously sent emails.

Table Specific Information

Select Emails from SentItems Subfolders

When performing a SELECT operation on the SentItems table, the driver will not include the items in the subfolders under SentItems, but only the items contained within the SentItems folder. If you wish to retrieve the items under the SentItems subfolders, your will need to specify the ParentFolderId-s in the WHERE clause. You can get every SentItems subfolder Id by executing a filtered by ParentFolderName query to the Folders table. You can use the example query below, to retrieve the items within the SentItems subfolders:

SELECT * FROM SentItems WHERE ParentFolderId IN (SELECT FolderId FROM Folders WHERE ParentFolderName = 'SentItems' AND TotalCount > 0)

Update and Delete

The driver will need the ItemChangeKey to update or delete an item. However, if you are unsure of the ItemChangeKey, the driver is able to retrieve it from the Exchange server automatically. Note that this may increase the time it takes to perform a query.

Columns


Name	Type	ReadOnly	Description
ItemId [KEY]	String	True	Uniquely identifies an item within the Exchange store. This value remains constant for the item's lifetime and is used to retrieve or manipulate the item programmatically.
MimeContent	String	True	Contains the raw MIME stream of the email message, encoded in Base64. This includes headers, body content, and attachments as formatted by the email client.
ItemChangeKey	String	True	Provides a unique version identifier for the item. It changes each time the item is updated and is required for concurrency control and synchronization.
ParentFolderId	String	False	Specifies the unique identifier of the folder that directly contains the item. This value is used to determine the item's hierarchical location in the mailbox.
ParentFolderChangeKey	String	True	Identifies the current version of the parent folder. Used in synchronization and conflict detection to track changes to the parent container.
ItemClass	String	False	Indicates the message type of the item, such as IPM.Note for standard emails or IPM.Appointment for calendar entries. Helps determine item handling rules.
Subject	String	False	Contains the subject line of the item, often displayed as the email title. Limited to 255 characters to ensure compatibility with various clients and services.
Sensitivity	String	True	Describes how confidential the item is. Possible values include Normal, Personal, Private, and Confidential, which can restrict how the message is displayed or forwarded.
Body	String	False	Stores the full content of the message body, either as plain text or HTML. Includes the main communication content that users compose and read.
DateTimeReceived	Datetime	True	Captures the exact timestamp when the item was delivered to the recipient's mailbox. Used for sorting and time-based filtering.
Size	Integer	True	Represents the total size of the item in bytes, including headers, body, and attachments. This property is read-only and used to track mailbox usage.
Categories	String	False	Lists the custom category labels assigned to the item by the user. These are used for color-coding, organization, and filtering within email clients.
Importance	String	False	Indicates the priority level assigned to the item by the sender. Common values include Low, Normal, and High, affecting how the message is presented.
InReplyTo	String	False	References the item Id of the original message being replied to. Helps maintain message threading and conversation grouping.
IsSubmitted	Boolean	True	True if the item has been submitted to the Outbox and is awaiting transmission. Used internally by Exchange to track delivery state.
IsDraft	Boolean	True	True if the item is a draft that has not yet been sent or submitted. Drafts are typically saved manually or automatically during message composition.
IsFromMe	Boolean	True	True if the sender and recipient are the same mailbox. Useful for detecting self-addressed messages or automated copies.
IsResend	Boolean	True	Indicates whether the item is a re-sent version of a previously sent message. Helps differentiate between original sends and retries.
IsUnmodified	Boolean	True	True if the item has not been changed since it was first received or created. Helps detect user edits or processing updates.
InternetMessageHeaders	String	True	Holds the complete set of Internet-standard message headers as a single string. This includes metadata like 'Received', 'From', 'To', 'Message-ID'.
DateTimeSent	Datetime	True	Marks the date and time when the message was successfully sent from the Outbox. Often used in audits or delivery confirmation.
DateTimeCreated	Datetime	True	Stores the creation timestamp of the item. This is when the message was first drafted or system-generated within the mailbox.
ReminderDueBy	Datetime	False	Specifies the exact time a reminder is due to alert the user, based on the event's scheduled time and any configured offset.
ReminderIsSet	Boolean	False	True if the user has configured a reminder for this item, prompting alerts prior to a deadline, meeting, or task.
ReminderMinutesBeforeStart	Integer	False	Specifies how many minutes before a scheduled calendar event a reminder will trigger and display to the user. This setting helps users manage upcoming commitments effectively.
DisplayCc	String	True	Contains the formatted string of all display names listed in the Cc (carbon copy) field of the email. Useful for rendering the message's visual representation in client applications.
DisplayTo	String	True	Contains the formatted string of all display names listed in the To field of the email. This field reflects how primary recipients are visually presented in the user interface.
HasAttachments	Boolean	True	Indicates whether the email message or item includes one or more file or item attachments. A value of true means attachments are present, allowing downstream processes to handle them accordingly.
Culture	String	False	Specifies the cultural or locale information associated with the item, such as language and regional settings, typically used for proper formatting of dates, times, and other locale-sensitive content.
SenderName	String	False	Represents the full display name of the sender as configured in the sender's mailbox or directory entry. This name is typically shown in email clients.
SenderEmailAddress	String	False	Provides the SMTP email address of the sender, enabling clients and services to identify and reply to the message originator.
SenderRoutingType	String	False	Specifies the messaging routing protocol used to send the item from the sender, such as SMTP. This helps distinguish between various transport mechanisms in multi-protocol environments.
ToRecipients_Names	String	False	Contains the list of display names for all primary (To) recipients of the message, presented in a single, comma-separated string.
ToRecipients_EmailAddresses	String	False	Lists the SMTP email addresses of all primary recipients (To) in a comma-separated string, enabling external processing or delivery validation.
ToRecipients_ItemIds	String	False	Provides the unique item identifiers for each primary recipient listed in the To field. These IDs can be used to retrieve additional metadata or link with related objects.
CcRecipients_Names	String	False	Contains the list of display names for all recipients included in the Cc field. Useful for email display formatting and recipient recognition.
CcRecipients_EmailAddresses	String	False	Lists the SMTP email addresses of all Cc recipients in a comma-separated format, supporting both UI display and backend processing.
CcRecipients_ItemIds	String	False	Provides the unique item identifiers for each recipient listed in the Cc field. These identifiers are useful for tracking and cross-referencing recipients programmatically.
BccRecipients_Names	String	False	Contains the list of display names for all recipients in the Bcc (blind carbon copy) field. These names are typically not visible to regular recipients but can be processed for audit or delivery purposes.
BccRecipients_EmailAddresses	String	False	Lists the SMTP email addresses of all Bcc recipients, separated by commas. This field is critical for systems that track delivery while preserving recipient privacy.
BccRecipients_ItemIds	String	False	Stores the unique identifier for each recipient listed in the blind carbon copy (Bcc) field of the sent message. This allows for tracking and auditing of hidden recipients.
IsReadReceiptRequested	Boolean	False	Specifies whether the sender has requested a read receipt notification, which informs them when the recipient opens the message.
IsDeliveryReceiptRequested	Boolean	False	Indicates whether the sender has requested a delivery receipt, confirming that the message was successfully delivered to the recipient's mailbox.
ConversationIndex	String	False	Contains a system-generated binary value that uniquely identifies the conversation thread to which this message belongs, allowing for message threading and grouping in clients like Outlook.
ConversationTopic	String	False	Holds the subject or topic of the conversation thread, used to logically group related email messages into discussions or chains.
FromName	String	False	Displays the display name of the sender's email account, representing the human-readable name associated with the From address.
FromEmailAddress	String	False	Captures the email address (in SMTP format) of the user who sent the message, used for routing and reply functionality.
FromRoutingType	String	False	Specifies the addressing type used to route the sender's email address. Typical values include SMTP, X500, or EX. The default is SMTP.
InternetMessageId	String	False	Stores the globally unique message identifier assigned to the email by the sending system. This ID is used for message correlation and referencing across mail systems.
IsRead	Boolean	False	Indicates whether the message has been marked as read by the recipient. This value is typically updated by the email client upon opening the message.
IsResponseRequested	Boolean	False	Determines whether the sender expects a response to the message, often used in meeting requests or actionable messages.
References	String	False	Contains the value of the 'References' header from the message, which is used to maintain threading by linking replies to the original message and prior responses.
EffectiveRights_CreateAssociated	Boolean	True	Indicates whether the user has permission to create associated content items in the folder, such as hidden metadata or custom forms.
EffectiveRights_CreateContents	Boolean	True	Indicates whether the user has rights to create new mail items or content within the folder represented by the current context.
EffectiveRights_CreateHierarchy	Boolean	True	Indicates whether the user has permission to create new subfolders within the current folder, contributing to the overall mailbox hierarchy.
EffectiveRights_Delete	Boolean	True	Indicates whether the current client has permission to delete the associated folder or item. This is part of the effective access rights granted to the user.
EffectiveRights_Modify	Boolean	True	Specifies whether the user has permission to modify the content or properties of the associated folder or item.
EffectiveRights_Read	Boolean	True	Indicates whether the client is authorized to read the contents of the specified folder or item. This is a key aspect of user access control.
EffectiveRights_ViewPrivateItems	Boolean	True	Determines whether the client has been granted permission to view items marked as private within a folder, such as confidential calendar events.
ReceivedByName	String	False	Displays the full name of the user whose mailbox ultimately received the item. This is typically the final recipient's display name.
ReceivedByEmailAddress	String	False	Specifies the Simple Mail Transfer Protocol (SMTP) address of the mailbox that received the item. Used for identifying the recipient in email tracking.
ReceivedByRoutingType	String	False	Defines the routing protocol used to deliver the item to the ReceivedBy user. Common values include SMTP for email routing or EX for Exchange.
ReceivedRepresentingName	String	False	Shows the display name of the delegate or mailbox user on whose behalf the item was received, if applicable.
ReceivedRepresentingEmailAddress	String	False	Specifies the SMTP address of the user whom the delegate or automated process is representing in the transaction.
ReceivedRepresentingRoutingType	String	False	Indicates the message routing type used for the user being represented. The default is SMTP, but other values such as EX (Exchange) can appear.
LastModifiedName	String	True	Captures the display name of the last user who made changes to the item. Useful for audit tracking and versioning.
LastModifiedTime	Datetime	True	Records the timestamp of the most recent modification made to the item. This field is automatically set and read-only.
IsAssociated	Boolean	False	Specifies whether the item is an associated item within the folder. Associated items are hidden from the user interface and typically store metadata or configuration.
WebClientReadFormQueryString	String	True	Provides a query string to append to the Outlook Web App (OWA) endpoint that opens the item in read-only mode via a browser.
WebClientEditFormQueryString	String	True	Provides a query string to append to the Outlook Web App (OWA) endpoint that opens the item in edit mode for modification via a browser.
ConversationId	String	True	Uniquely identifies the conversation thread to which the item belongs within the Exchange mailbox. Used to group related messages together.
ConversationChangeKey	String	True	Stores the change key associated with the conversation or item. This key is used for concurrency control and versioning.
UniqueBody	String	True	Contains the portion of the message body that is unique to the item and not duplicated from previous messages in the conversation thread. May be in HTML or plain text.
UniqueBodyType	String	True	Indicates the format in which the unique body content is stored, such as 'HTML' or 'TEXT'. Helps determine how to render the body.
ReminderMessageData_Text	String	False	Represents the text message shown in a reminder notification for calendar events or tasks. It often includes a summary of the event.
ReminderMessageData_Location	String	False	Specifies the location information tied to the reminder event, such as a meeting room, virtual meeting link, or geographic address.
ReminderMessageData_StartTime	Datetime	False	Captures the start time of the event linked to the reminder message. This is used to trigger reminders in calendar-based scenarios.
ReminderMessageData_EndTime	Datetime	False	Captures the end time of the event linked to the reminder message. Together with StartTime, this defines the event duration.
ReminderMessageData_AssociatedCalendarId	String	True	Identifies the calendar item (appointment or meeting) that the reminder message is associated with. Useful for linking to the calendar event.
Attachments	String	True	Lists the identifiers of attachments associated with the item, separated by commas. Each identifier corresponds to a file or embedded object.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.