- Product Manual
- Introduction
- Installation Guide
- User Guide
- Quick Start Guide
- User Interface
- Configuration
- SMS Client software
- Ozeki SMS client
- Command line SMS client
- Excel SMS client
- Excel Client Macros
- Bulk messaging in Excel
- Compare Excel SMS Client to Excel SMS Client II.
- Excel SMS client II.
- Outlook SMS client
- Automatics SMS reply
- Administrator's guide
- Developers Guide
- Examples and Solutions
- Appendix
- SMS FAQ
- Feature list
- Commercial Information
- Search
Ozeki brings you outstanding
SMS Gateway technology. Use our SMS Server products on Windows,Linux, or Android
C# SMS API
Developers can use our C# SMS API to send SMS from C#.Net. The C# SMS API comes with full source code
PHP SMS API
The ozeki PHP SMS gateway software can be used to send SMS from PHP and to receive SMS usig PHP on your website
SMPP SMS Gateway
SMS service providers use our SMPP gateway solution, that offers a high performance SMPP server and SMPP client gateway with amazing routing capabilities
How to send bulk messages using Excel client
This page demonstrates an example on how to send great numbers of SMS text messages from Excel easily and swiftly. In case of huge numbers of SMS messages you need to export messages into CSV file format before sending. In this way Ozeki NG SMS Gateway will send out your messages seamless. Please follow the configuration steps and check the screen shots and video tutorial to adopt this solution properly.
How to send bulk messsages using Excel (part 1/1, configure your system)
Configuration guide
In our example there is an Excel file that contains SMS text messages. For a better demonstration I placed this file on the Desktop (Figure 1).
On Figure 2 you can see that the file contains 10,000 SMS text messages to be sent out.
Now you can learn how to send out these messages with Ozeki NG SMS Gateway in CSV file format. First, select columns C, D, and E in the Excel file (Figure 3).
Now delete the selected columns in the file (Figure 4).
Type =now() in C1 cell (Figure 5).
Now you need to select those cells of column C that contains messages to be sent out. You also need to select C1 cell. If it is done, click on "Fill" button in the toolbar and then click on "Down" (Figure 6).
Click on "Office" button and then select "Save as" option in the menu (Figure 7).
Select CSV file format in Save as type line (Figure 8).
Now start Ozeki NG SMS Gateway. Click on Add new user or application. Select File user interface and click on install next to it (Figure 9). In this way you can create a new user in the SMS gateway that will operates SMS sending in CSV file format.
On General tab select CSV as File format and click on OK (Figure 10).
Copy the saved CSV file (Figure 11).
Finally the CSV file needs to be pasted into the smsout folder of the File user (Figure 12).
The File user of Ozeki NG SMS Gateway sends the SMS text messages out seamless (Figure 13).
More information
- Ozeki SMS client
- Excel SMS client
- How to send SMS messages in CSV file format
- Outlook SMS client
- Excel SMS client macros
- SMS Service Provider Connectivity
- Users and SMS Applications
- SMS alphabet