Recipients property

EmailReportButton.Recipients — Text

Represents the primary recipients of an email sent through an email report button. The CarbonCopy and BlindCarbonCopy properties can also be used to address recipients.

This text string must consist of one or several email addresses. Multiple addresses may be separated by spaces, commas or semicolons. In formulas, use & to join text strings together. Use the TEXTJOIN function to convert an array of text strings to a text string suitable for use with this property.


"," & EmailAddress"," & EmailAddress

Sets the recipients of an email report button to two addresses: "" and to the value held by the field named EmailAddress.

TEXTJOIN(",", TRUE, EmailField1:EmailField30)TEXTJOIN(","; TRUE; EmailField1:EmailField30)

Sets the recipients of an email report button to the email addresses entered in the text fields EmailField1, EmailField30 and any text fields that appear between them, such as EmailField2. The second parameter to TEXTJOIN, TRUE, ensures that blank values are ignored.