Skip to content
REFERENCE

U.SEND_TEXT

Summary

Sends text with selected data and any specified attachments to specified recipients. Up to 10 text messages per machine is supported using default Runline SMS account. Runline does not have access to content of messages sent via default account

Syntax

=U.SEND_TEXT(to, message, [from], [throttle], [email_to], [email_from], [block])

Parameters

Parameter Required Description
to Yes Phone numbers to which message will be sent in E.164 format. Phone numbers can be in distinct cells and/or separated by a comma, colon, or newline
message Yes The content of the message to be sent. If multiple cells are selected, the contents of each will be separated in the message by a blank line
[from] No If multiple custom Twilio accounts are configured, indicates the account from which text message will be sent. If a single custom account is configured that will be used, otherwise default Runline account is used. An additional cell can include "alpha" or "short" to indicate that an associated Alphanumeric Sender ID or Short Code, respectively, should be used to send the message
[throttle] No The amount of time in seconds that must elapse before U.SEND_TEXT from the calling range of cells will be allowed to resend a text. Default is 60 seconds; if zero or negative then no throttling is applied. If 2 columns are provided and the 2nd value is FALSE, the text is not sent. If 3 columns are provided and 3rd value is TRUE an identical text can be sent on the same calendar day.
[email_to] No Email address(es) to which text message will also be sent
[email_from] No The "From" address used in the optional email. Required if "email_to" is specified and Microsoft Outlook is not installed and configured
[block] No If set to TRUE then method will not be calculated unless triggered by user interaction or calculated as a step in a script; If set to a number then will be throttled to not calculate more frequently than the specified number of seconds; make number negative to prevent auto recalc of blocked methods

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.SEND_TEXT(C70:71,C74:C75)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.