Skip to main content

MAIL.SEND

Send a mail using the given producer and parameters. You can use the Function Wizard for this function.

Syntax

=MAIL.SEND(Producer, Message, Subject, TO, CC, BCC, Attachments )

Arguments

NameDescription
ProducerMail Producer to use for sending mail.
MessageSimple text used as content of the mail
SubjectSimple text
TOSingle mail address or range of mail adresses.
CCSingle mail address or range of mail adresses.
BCCSingle mail address or range of mail adresses.
AttachmentsRange of Attachments, see example below.

Return Value

TRUE, if no error.

Examples

FunctionResultComment
=MAIL.SEND(|Mail Produer, “Message”, “Subject”, “user@example.org”)TRUESend a mail with the content “Message” and the subject “Subject” to “user@example.org” using the “Mail Producer”
=MAIL.SEND(|Mail Producer, “Message”, “Subject”, A1:B2, “user2@example.org”, “user3@example.org”)TRUESend a mail with the content “Message” and the subject “Subject” to all mail addresses in the A1:B2 range and with “user2@example.org” in CC and “user3@example.org” in BCC using the “Mail Producer”.
=MAIL.SEND(|Mail Prodcuer, “Message”, “Subject”, “user@example.org”, , , A3:D4)
TRUESend a mail with two attachments.
The first attachment is text file name “file.txt” with “A text” as content. The second attachment is an image named “image.jpeg” with the base64 value of the image as content.
The encoding defaults to “utf-8” and could be omitted for “file.txt”. The “Content-Type” column is optional and not required in most cases since the Content-Type will be determined from the file extension.