sendMail

The sendMail procedure can be used to send emails through an SMPT server.

To use it, a properly configured SMTP server is needed. An SMTP server can be configured using the setSmtpConfiguration procedure.

Usage

SQL

CALL "UTILS.sendMail"(
    "Recipients" => 'string_Recipients',
    "Subject" => 'string_Subject',
    "Body" => 'string_Body',
    "AttachmentNames" => array('string_AttachmentName'),
    "Attachments" => array(blob_Attachment),
    "AttachmentMimeTypes" => array('string_AttachmentMimeType')
)

Parameters

Parameter	Description
`Recipients`	Comma-separated list of recipients
`Subject`	Email subject
`Body`	Email body
`AttachmentNames`	Array of attachment names
`Attachments`	Array of attachments
`AttachmentMimeTypes`	Array of attachments MIME types

Example

SQL

CALL "UTILS.sendMail"(
    "Recipients" => 'example@example.org',
    "Subject" => 'Testmail',
    "Body" => 'Hello world.',
    "Attachments" => array(
        (SELECT file FROM (CALL "file.getFiles"() ) a WHERE a.filePath like 'currencyconvertor.asmx'),
        (SELECT file FROM (CALL "file.getFiles"() ) a WHERE a.filePath like 'currencyconvertor.wsdl')
    ),
    "AttachmentNames" => array('currencyconvertor.asmx', 'currencyconvertor.wsdl'),
    "AttachmentMimeTypes" => array('application/asmx', 'application/wsdl')
) ;;