Tableau Connector for Gmail

Build 24.0.9062

SendMailMessage

Sends a message to the specified recipient.

ストアドプロシージャ固有の情報

このプロシージャを使用してE メールを送信します。

ファイルを1つだけ添付する例です。

EXECUTE SendMailMessage @Subject = 'subject', @To = 'email', @From = 'sender_email', @CC = 'email', @BCC = 'email', @Content = 'content', @AttachmentPath = 'C:\\MyDirectory\\MyFile.extension'

ディレクトリの最初の階層の、すべてのファイルを添付する例です。

EXECUTE SendMailMessage @Subject = 'subject', @To = 'email', @From = 'sender_email', @CC = 'email', @BCC = 'email', @Content = 'content', @AttachmentPath = 'C:\\MyDirectory'

複数のファイルとフォルダを、組み合わせて添付する例です。

INSERT INTO attach#TEMP (AttachmentPath) VALUES ('C:\\MyDirectory\\MyFile.extension')
INSERT INTO attach#TEMP (AttachmentPath) VALUES ('C:\\MyDirectory2')
EXECUTE SendMailMessage @Subject = 'subject', @To = 'email', @From = 'sender_email', @CC = 'email', @BCC = 'email', @Content = 'content', @AttachmentPath = 'attach#TEMP'

複数のメール受信者を含める場合の例です。

EXECUTE SendMailMessage @Subject = 'subject', @To = '[email protected],[email protected]', @From = 'sender_email', @CC = '[email protected],[email protected]', @BCC = '[email protected],[email protected]', @Content = 'content'

Input

Name Type Required Description
Subject String True The subject of the mail message.
To String True The email address(es) of the recipient(s).
From String False The email address of the sender.
CC String False CCed recipient(s).
BCC String False BCCed recipient(s).
Content String True The message body.
AttachmentPath String False The attachment file names (with the path if reading from a file) to include in the message.

Result Set Columns

Name Type Description
Id String The Id for the message as returned by the server.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062