---
title: "MAILS (Outlook)"
description: "Mails"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/microsoftoutlook/Outlook.Mails.MAILS
original: https://documentation.invantive.eu/en/datamodels/microsoftoutlook/Outlook.Mails.MAILS
updated: 2026-05-19T09:58:29Z
license: https://documentation.invantive.eu/en/
---

# MAILS: Outlook Mails

`insert` `update` `delete`

- Catalog: `Outlook`
- Schema: `Mails`
- Primary Keys: `EntryID`
- Label: Mails

Can retrieve data and change data using `insert`, `update` and `delete`.

## Summary

Outlook mails.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `folderEntryId` | `` | [ ] |  | Unique ID of the folder as a reference to the table 'FOLDERS'. |
| `includeFullBody` | `` | [ ] |  | Whether to include the full body text. |
| `storeEntryId` | `` | [ ] |  | Unique ID of a store as a reference to the table 'FOLDERS' when queried with include external stores. |

## Table Columns

The columns of the table `MAILS` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `AlternateRecipientAllowed` | `boolean` |  | [ ] |  |  |
| `AutoForwarded` | `boolean` |  | [ ] |  |  |
| `BCC` | `varchar2` |  | [ ] |  |  |
| `BillingInformation` | `varchar2` |  | [ ] |  |  |
| `Body` | `varchar2` |  | [ ] |  |  |
| `Categories` | `varchar2` | Categories | [ ] |  |  |
| `CC` | `varchar2` |  | [ ] |  |  |
| `ConversationIndex` | `varchar2` |  | [ ] |  |  |
| `ConversationTopic` | `varchar2` |  | [ ] |  |  |
| `CreationTime` | `datetime` |  | [ ] |  |  |
| `DeferredDeliveryTime` | `datetime` |  | [ ] |  |  |
| `DeleteAfterSubmit` | `boolean` |  | [ ] |  |  |
| `EntryID` | `varchar2(1024)` |  | [ ] |  |  |
| `ExpiryTime` | `datetime` |  | [ ] |  |  |
| `FlagDueBy` | `datetime` |  | [ ] |  |  |
| `FlagRequest` | `varchar2` |  | [ ] |  |  |
| `FlagStatus` | `numeric` |  | [ ] |  |  |
| `FolderID` | `varchar2(1024)` |  | [ ] |  |  |
| `HTMLBody` | `varchar2` |  | [ ] |  |  |
| `Importance` | `numeric` |  | [ ] |  |  |
| `LastModificationTime` | `datetime` |  | [ ] |  |  |
| `MarkForDownload` | `numeric` |  | [ ] |  |  |
| `Mileage` | `varchar2` |  | [ ] |  |  |
| `NoAging` | `boolean` |  | [ ] |  |  |
| `OriginatorDeliveryReportRequested` | `boolean` |  | [ ] |  |  |
| `ReadReceiptRequested` | `boolean` |  | [ ] |  |  |
| `ReceivedByName` | `varchar2` |  | [ ] |  |  |
| `ReceivedOnBehalfOfName` | `varchar2` |  | [ ] |  |  |
| `ReceivedTime` | `datetime` |  | [ ] |  |  |
| `RecipientReassignmentProhibited` | `boolean` |  | [ ] |  |  |
| `ReminderOverrideDefault` | `boolean` |  | [ ] |  |  |
| `ReminderPlaySound` | `boolean` |  | [ ] |  |  |
| `ReminderSet` | `boolean` |  | [ ] |  |  |
| `ReminderSoundFile` | `varchar2` |  | [ ] |  |  |
| `ReminderTime` | `datetime` |  | [ ] |  |  |
| `RemoteStatus` | `varchar2` |  | [ ] |  |  |
| `ReplyRecipientNames` | `varchar2` |  | [ ] |  |  |
| `SenderEmailAddress` | `varchar2` |  | [ ] |  |  |
| `SenderEmailType` | `varchar2` |  | [ ] |  |  |
| `SenderName` | `varchar2` |  | [ ] |  |  |
| `Sensitivity` | `numeric` |  | [ ] |  |  |
| `SentOn` | `datetime` |  | [ ] |  |  |
| `SentOnBehalfOfName` | `varchar2` |  | [ ] |  |  |
| `Size` | `numeric` |  | [ ] |  |  |
| `StoreID` | `varchar2(1024)` |  | [ ] |  |  |
| `Subject` | `varchar2` |  | [ ] |  |  |
| `TaskCompletedDate` | `datetime` |  | [ ] |  |  |
| `TaskDueDate` | `datetime` |  | [ ] |  |  |
| `TaskStartDate` | `datetime` |  | [ ] |  |  |
| `To` | `varchar2` |  | [ ] |  |  |
| `ToDoTaskOrdinal` | `datetime` |  | [ ] |  |  |
| `UnRead` | `boolean` |  | [ ] |  |  |
| `VotingResponse` | `varchar2` |  | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Outlook](/en/release-notes/drivers?driver=outlook)

