Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozekisms.com
Tel.: 00 36 52 532 731
SMS Gateway to send SMS via GSM modem or IP SMS connection Overview SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Quick start SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Download SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Manual SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection How to buy SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection FAQ SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Contact Us SMS Gateway to send SMS via GSM modem or IP SMS connection
OZEKI NG SMS Gateway - Product Guide

Excel Client Macros Contents | SearchCompare Excel SMS Client to Excel SMS Client II.

Home > Product Manual > User Guide > Client software > Excel SMS client > Bulk messaging in Excel

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  User Guide
  Quick Start Guide
  User Interface
  Configuration
  Client software
  Outlook Client
  Ozeki SMS client
  Excel SMS client
  Excel Client Macros
  Bulk messaging in Excel
  Compare Excel SMS Client to Excel SMS Client II.
  Command line client
  Excel SMS client II.
  Ozeki NG Autoreply client
  Administrator's guide
  Developers Guide
  Examples and Solutions
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
  Cookie policy
 


Automated phone calls?
Ozeki Phone System XE VoIP PBX software is an advanced PBX built for automated voice calls and 2 way SMS messaging. It has outstanding APIs for software developers. It can be used for:

Phone calls from SQL
Phone calls from HTTP
Voice and SMS applications

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create VoIP client and server software.

Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

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.

Video: 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).


Figure 1 - Excel file with SMS messages

On Figure 2 you can see that the file contains 10,000 SMS text messages to be sent out.


Figure 2 - 10,000 SMS 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).


Figure 3 - Select columns C, D, E

Now delete the selected columns in the file (Figure 4).


Figure 4 - Delete selected columns

Type =now() in C1 cell (Figure 5).


Figure 5 - Fill C1 cell

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).


Figure 6 - Select the filled cells of column C

Click on "Office" button and then select "Save as" option in the menu (Figure 7).


Figure 7 - Select Save as option

Select CSV file format in Save as type line (Figure 8).


Figure 8 - Select CSV file format

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.


Figure 9 - Create a File user in Ozeki NG SMS Gateway

On General tab select CSV as File format and click on OK (Figure 10).


Figure 10 - CSV as file format

Copy the saved CSV file (Figure 11).


Figure 11 - Copy the saved CSV file

Finally the CSV file needs to be pasted into the smsout folder of the File user (Figure 12).


Figure 12 - Paste the CSV file into smsout folder

The File user of Ozeki NG SMS Gateway sends the SMS text messages out seamless (Figure 13).


Figure 13 - File user sends out the messages

Dig deeper!
People who read this also read...


Excel SMS client

How to send SMS messages in CSV file format



Next page: Compare Excel SMS Client to Excel SMS Client II.

Copyright © 2000 - 2017 Ozeki Informatics Ltd.
All rights reserved

Software PBX for Windows | VoIP SDK   |   Legal information   |   Privacy policy   |   Terms of use
Please, address your inquiries to info@ozekisms.com