- Product Manual
- SMS technology
- Installation Guide
- User Guide
- Quick Start Guide
- User Interface
- 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
- SMS FAQ
- Feature list
- Commercial Information
Sending SMS messages from Excel
On this page you can learn how to send SMS messages from Excel using the Ozeki NG - SMS Gateway software. You can read a short introduction about the Excel files you need to use, and you are provided with details about the Messages.xls spreadsheet, explaining what each column is for. You can also learn how to configure the Excel macro connection and how to set the appropriate security level in the Excel client file to allow sending messages.
The Excel SMS client of Ozeki NG - SMS Gateway enables you to send SMS messages from Microsoft Excel. For this, you just need to open two Excel spreadsheets: Messages.xls and Ozeki.xls. In the Messages.xls spreadsheet, you need to put the telephone numbers in the first and the messages in the second column. To learn what the other columns are for, read the Messages spreadsheet section below.
In the Ozeki.xls Excel spreadsheet you will find a macro you can start by clicking the Send all button. This macro will connect to Ozeki NG - SMS Gateway over the office LAN or the Internet and will send the SMS messages you have edited in the Messages.xls spreadsheet. The parameters for this network connection can be edited on the Ozeki.xls spreadsheet.
Using the Excel Client allows you to keep a record of the SMS messages you have sent in an Excel spreadsheet. You can identify which of the messages you have sent belongs to a given telephone number. They are in the same row in the spreadsheet.
For sending messages, the Ozeki NG - SMS Gateway program and Excel do not need to be on the same computer. You can send messages from different computers in an office network. You just need to enter the IP of the server PC running Ozeki NG - SMS Gateway (Figure 1).
Both Excel files you have to use can be found in the C:\Program Files\Ozeki\OzekiNG - SMS Gateway directory after the program has been installed. (From here, they can be moved to any other folder.) You can also open the Excel files by clicking their icons below the Manage OzekiNG file icon (Figure 2).
The main steps of sending SMS messages from Excel are:
- Creating a list of messages
- Opening the Excel file sending SMS
- Starting the macro sending SMS
- Sending out messages
First, make sure the Ozeki NG - SMS Gateway program has started. If not, start it. (For details, check out the What to do if the service is not running section on the Login problems page.)
Open the Messages Excel spreadsheet for editing the telephone numbers and the texts of the SMS messages. Open the spreadsheet by clicking its icon to do the editing (Figure 2).
Once you have opened this Excel file, you can start entering, in the appropriate cells, all the information required for SMS messages to be sent (Figure 3). In Excel, entering information in or applying a function to a range of cells can be done by typing, copying and pasting or dragging cells.
The Messages spreadsheet
The information related to a message to be sent is in different cells of the same row in the Excel spreadsheet. Some of the information has to be entered/edited manually, and some will be entered/edited automatically. Each cell involved in the editing requires a specific kind of information.
- The cell in Column A is for the telephone number you are going to send the message to. Enter the telephone number in international format (starting with + and the country code, without using any spaces).