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

Name

Description

Producer

Mail Producer to use for sending mail.

Message

Simple text used as content of the mail

Subject

Simple text

TO

Single mail address or range of mail adresses.

CC

Single mail address or range of mail adresses.

BCC

Single mail address or range of mail adresses.

Attachments

Range of Attachments, see example below.

Return Value

TRUE, if successful.

Examples

Function

Result

Comment

=MAIL.SEND(“Mail Produer”, “Message”, “Subject”, “user@example.org”)

TRUE

Send 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”)

TRUE

Send 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)

MAIL.SEND

TRUE

Send 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.