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 no error.
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) | 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. |