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 addresses.
CC	Single mail address or range of mail addresses.
BCC	Single mail address or range of mail addresses.
Attachments	Range of Attachments, see example below.

Return

TRUE, if no error.

Examples

Formula	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)	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.