Use one row per recipient, with the same message copied down alongside the numbers. Each recipient receives a separate SMS.
Video walkthrough #
- Open the Message List sheet. Enter the recipients in the Receiver column, one number per row, including each number’s country code.
- Write your message in the first recipient’s Text Message cell.
- Drag that cell’s bottom-right fill handle down to the last recipient. Check that every intended row has both a number and the complete message.
- Test with one number you control before preparing the full list. Click Send Messages and review any confirmation before sending.
A successful transmission to your phone is not proof that the recipient received it. Check your phone’s SMS app and the test recipient before sending the full list.