JDBC Driver for Gmail

Build 20.0.7654


Sends the message specified to the specified recipient.

Stored Procedure Specific Information

Send an email by using this procedure

Example to attach only one file:

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

Example to attach all files of the first level on a directory:

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

Example to attach a combination of multiple files and folders:

Insert into attach#temp (AttachmentPath) VALUES ('C:\\MyDirectory\\MyFile.extension')
Insert into attach#temp (AttachmentPath) VALUES ('C:\\MyDirectory')
EXECUTE SendMailMessage @Subject='subject', @To='email', @CC='email', @Content='content', @AttachmentPath='attach#temp'


Name Type Required Description
To String True The email address of the recipient.
From String False The email addresses of the sender.
Subject String True The subject of the mail message.
Content String True The message body.
CC String False CCed recipient.
BCC String False BCCed recipient.
AttachmentPath String False A semicolon-separated list of the attachment file names (with the path if reading from a file) included in the message.

Result Set Columns

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654