toText.net is very pleased to announce today the launch of our bulk text message sending feature.
Text messages can be specified in a spreadsheet that can be uploaded and then sent. The messages within the spreadsheet can be customised for each recipient, so you don’t have to send exactly the same message to each recipient.
The first line of the spreadsheet must be a header that defines the data, and each subsequent line represents the text messages that are to be sent.
It is very important that the spreadsheet is in .csv format, as .xls is not supported. You may need to select File, Save As… to get the required format.
Example 1:
The simplest form of the file to upload consists of a set of fixed messages to be sent to one or more mobiles, for example:
MOBILE,MESSAGE 447000000001,Sale now on! Big Savings. From ExampleShop.com 447000000002,Sale now on! Big Savings. From ExampleShop.com 447000000003,Sale now on! Big Savings. From ExampleShop.com 447000000004,Sale now on! Big Savings. From ExampleShop.com 447000000005,Sale now on! Big Savings. From ExampleShop.com
Example 2:
It is also possible to customise the message that is sent to each person. This is done by including one or more additional columns. Wherever the name of the additional columns is found within any of the messages, then the value of that row of the column will be inserted into the message.
MOBILE,BALANCE,MESSAGE 447000000001,10,Your book has arrived, outstanding balance £BALANCE 447000000002,14,Your book has arrived, outstanding balance £BALANCE 447000000003,8,Your book has arrived, outstanding balance £BALANCE 447000000004,20,Your book has arrived, outstanding balance £BALANCE 447000000005,30,Your book has arrived, outstanding balance £BALANCE
This means that the messages that are sent would be as follows:
447000000001: Your book has arrived, outstanding balance £10 447000000002: Your book has arrived, outstanding balance £14 447000000003: Your book has arrived, outstanding balance £8 447000000004: Your book has arrived, outstanding balance £20 447000000005: Your book has arrived, outstanding balance £30
Example 3:
Any number of extra columns can be inserted to allow your messages to be highly customised:
MOBILE,BALANCE,NAME,MESSAGE 447000000001,10,Mr Jones,Your book has arrived NAME, outstanding balance £BALANCE 447000000002,14,Miss Smith,Your book has arrived NAME, outstanding balance £BALANCE 447000000003,8,Dr Jenkins,Your book has arrived NAME, outstanding balance £BALANCE 447000000004,20,Mr White,Your book has arrived NAME, outstanding balance £BALANCE 447000000005,30,Mrs Green,Your book has arrived NAME, outstanding balance £BALANCE
This means that the messages that are sent would be as follows:
447000000001: Your book has arrived Mr Jones, outstanding balance £10 447000000002: Your book has arrived Miss Smith, outstanding balance £14 447000000003: Your book has arrived Dr Jenkins, outstanding balance £8 447000000004: Your book has arrived Mr White, outstanding balance £20 447000000005: Your book has arrived Mrs Green, outstanding balance £30