MailMessages

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

このスキーマはすべてのテーブルに定義されます。すべてのテーブル名はサーバーのメールボックスフォルダとなります。

テーブル固有の情報

メールボックスフォルダのテーブル名をエスケープするには、角かっこを使うことができます。

プロトコル情報

このテーブルをIMAP、POP、およびSMTP と使うための詳細は、サポートされるMail プロトコルを参照してください。

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. To set this field, specify a single Id in SELECT or set IncludeMessage to true.
MessageDisplayText	String	False	A text representation of an email's content. It displays either the HTML content or plain text, depending on the value provided by IsHTML connection property or pseudo-column. To set this field, specify a single Id in SELECT or set IncludeMessage to true.
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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。