View source for How to Use CSV Compose

Compose CSV in iSMS involves very simple steps. When you send SMS messages via CSV file upload, you can customise or send text messages in bulk. Thus, using less time and effort to achieve your SMS marketing goal.


'''NOTE:'''

If you intend to send personalised SMS via CSV, you must follow the format and fill in your data accordingly. Please refer to [[Personalised SMS|How to Compose Personalised SMS]] for more details.

'''Example :Hi %name%, your credit balance is %amount %, please make payment %string1%'''

'''Final Result Hi JOHN, your credit balance is 300, please make payment to test 1'''


'''To learn how to convert Microsoft Excel to CSV, please refer to [[How_to_Convert_Microsoft_Excel_to_CSV|How to Convert Microsoft Excel to CSV]].'''


1. Login to iSMS member console.

[[File:isms-bulk-sms-csv-compose-sample-1.jpg|thumb|500px|center|Illustration 1: Login iSMS]]


2. Go to "Compose SMS with upload CSV File"

[[File:isms-bulk-sms-csv-compose-sample-2.jpg|thumb|500px|center|Illustration 2: Go to Compose CSV]]


3. Select "CSV Compose" tab.

[[File:isms-bulk-sms-csv-compose-sample-3b.jpg|thumb|500px|center|Illustration 3: Compose CSV]]


4. Browse and select your CSV file. It must be a CSV (Comma delimited) file.

[[File:bulk-sms-csv-compose-1.jpg|thumb|500px|center|Illustration 4: Upload CSV file]]


3. Key in your message into "Message" text area. 

You may leave the non related columns blank. The mobile number of the recipients must begin with prefix 60.

[[File:bulk-sms-csv-compose-2.jpg|thumb|500px|center|Illustration 5: Insert Message]]


4. Click "Send Now" to send SMS 

[[File:bulk-sms-csv-compose-3.jpg|thumb|500px|center|Illustration 6: Send SMS]]


'''To learn how to convert Microsoft Excel to CSV, please refer to [[How_to_Convert_Microsoft_Excel_to_CSV|How to Convert Microsoft Excel to CSV]].'''