Today, we will be looking at how to send Personalised SMS to a group of contacts on our website. Personalised messages give a feel of importance to the recipient and are also well appreciated. Personalised messages are used for Transaction Alerts, Seasonal wishes and many more. Organisations like Cooperatives, Loan Service companies, Schools, Neighbourhood Associations and many others use this as a key tool to send detailed updates/reports about the activities of their member. Examples of such messages are: Dear John, your account balance with XYZ Cooperative as at October 2015 is N2,000 or Dear Sunday, congratulations on your Birthday.
To send the message, follow the steps below:
- Open a new MS Excel Workbook.
- Enter the Variables needed in this format.
| 2347039444444 | Kola | N2,000 |
| 2348077774445 | Jude | N3,000 |
| 2347039444444 | Shola | N5,000 |
| 2347039444444 | Kelvin | N10,000 |
| 2347039444444 | Hassan | N20,000 |
The first column should contain all the phone numbers, while the 2nd Column and others should contain the Variables needed.
3. Save the file with File Type as: CSV (Comma Delimited)
4. Log in to www.kudisms.net
5. Click Messaging
6. Click Personalised SMS
7. Click Browse to Browse to upload the .CSV file created earlier.
8. Enter your SENDER ID
9. Enter your Message in this format:
Dear {1} your account Balance at the end of October 2015 is {2}
Note. {1} represents the Variable in the second column while {2} represents the variable in the third column. You can add values to more columns as you desire.
10. Click Send (NB: You can also schedule the message for later delivery)
Result: The message will be sent out and received by each recipient as, Dear John , your account Balance at the end of October 2015 is N2,000