MailMessages

List, search, delete, and move IMAP messages. List and delete POP messages. And send messages with SMTP.

This schema is defined for all tables. Each table name will be a mailbox folder on the server.

Table Specific Information

You can use square brackets to escape the table names of mailbox folders.

Protocol Information

For more specifics on using this table with IMAP, POP, and SMTP, refer to Supported Mail Protocols.

Deprecation notice for Gmail users

From May 30, 2022, Google no longer supports the use of third-party apps or devices which ask you to sign in to your Google Account using only your username and password. There are alternatives that allow your continued use of our Email drivers to connect to your Google account, which is why Gmail-specific columns, pseudo-columns, and stored procedures are only getting deprecated. We recommend you move to our Gmail drivers that offer more secure methods of authentication.

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	Identifier of the mail message.
Mailbox	String	True	The current mailbox that the item is listed in.
Subject	String	False	The subject of the current message.
From	String	True	The sender email address of the current message.
FullFrom	String	True	The sender name and email address of the current message.
To	String	False	The semicolon-separated list of email addresses of the recipients.
FullTo	String	False	The semicolon-separated list of names and email addresses of the recipients.
CC	String	False	The semicolon-separated list of names and email addresses of the CCed recipients.
BCC	String	False	The semicolon-separated list of names and email addresses of the BCCed recipients (only applicable for sent mail).
Date	String	True	The date the current message was sent.
MessageBody	String	False	The message body. Available only if you specify a single Id in SELECT.
Attachments	String	False	Semicolon-separated list of the attachment file names (with path if reading from a file) included in the message.
AttachmentData	String	False	Semicolon-separated list of the base-64-encoded attachment data included in the message. (You must still specify the file name in Attachments.)
Size	Int	True	The size in bytes of the current message.
Flags	String	False	The flags set on the current message.
Labels	String	False	The labels of the message, separated by spaces. Gmail treats labels as mailboxes.
ThreadId	String	True	The Gmail thread Id associated with the current message. Several messages may have the same thread Id.
MsgId	String	True	The message Id associated with the current message. For Gmail, this is a globally unique Id assigned by Google separate from the IMAP Id/UID.
PartIds	String	True	The Id of the message part.
PartFilenames	String	True	The file name of the message part.
PartContentTypes	String	True	The content type of the message part.
PartSizes	String	True	The size of the message part.
Headers	String	True	The message headers for the specified mail message. Available only if you specify a single Id in SELECT.
AttachmentHeaders	String	True	A newline-separated list of the headers associated with each attachment.
ContentIds	String	True	A semicolon-separated list of Content-Id headers for each attachment.

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.