Preparing your Excel 97-2003 Workbook file for sending Bulk SMS

Download Sample Excel 97-2003 Workbook (*.xls) File
 
1. Login to your Cute SMS account page.
2. In the Message section, click Bulk SMS.
3. Click on Download Sample in the left pane of the window. This action will allow you to download sample spreadsheet named: sample.xls
 
Preparing your Excel 97-2003 Workbook (*.xls) file
 
4. Open the downloaded Excel 97-2003 Workbook (*.xls)
5. Ensure your data is captured on sheet 1 of the workbook and not on any other sheet(s)
6. Remove all headings and other sheets that might contain data
7. All mobile numbers must be entered in column A, starting in row 2 with the first number in cell A2
8. Columns B to D are used to store information that allows for personalisation of messages – the fields are alphanumeric and can be used either for alpha, numeric or a combination of alpha and numeric
 
Message required example:
 
Dear parent of xxxxxxxxxx, you are requested to pay the bus fee of INR xxxxxxxxxx for the month of xxxxxxxxxx. Regards PRINCIPAL, Rose Mary School
 
Template required example:
 
Dear parent of ##STUDENT##, you are requested to pay the bus fee of INR ##AMOUNT## for the month of ##MONTH##. Regards PRINCIPAL, Rose Mary School
 
Excel sheet example:
 
 
Result:
 
Dear parent of Aravind, you are requested to pay the bus fee of INR 500 for the month of Jan 2017. Regards PRINCIPAL, Rose Mary School
 
Dear parent of Sudhagar, you are requested to pay the bus fee of INR 550 for the month of Feb 2017. Regards PRINCIPAL, Rose Mary School
 
Dear parent of Xavier, you are requested to pay the bus fee of INR 700 for the month of Mar 2017. Regards PRINCIPAL, Rose Mary School
 
Save your Excel File as a XLS (Excel 97-2003 Workbook (*.xls)) FILE
 
1. In the Excel file containing the contact information, select File and Save As.
2. File name; rename the file (optional), under Save as type: select XLS (Excel 97-2003 Workbook (*.xls)).
3. Click Save

Add Feedback