Excel sms plugin MobonAir sms sender, you may send SMSs directly from your Excel sheet with the MobonAir Upgraded UI2022 Excel plugin sms sender. This tutorial will coach you through the few easy steps needed to configure Excel to SMS in your Mobonair account.
1. Excel sms Plugin-Create Login and add credits
choose one bulk sms package from plan and payment option and get user name and pasword from their . Click Here
Add credits to your bulk sms account
You need credits in your Mobonair account in order to send SMS using the plugin. For each SMS of up to 160 characters, one credit is spent. In the dashboard’s upper right corner, you can view your current credit balance. You can log in to the website and select the “Buy” button in the top right corner to buy credits.
2. Excel sms Plugin -Download & install the plugin
Download the plugin and install it
- Go to this page from Office Store
- Click on ‘Add’ button, it takes you to the template install page
- Then click on ‘Open in Excel’ which downloads an excel sheet
- Open the sheet, click on ‘Enable editing’ and then ‘Trust this add-in’ to finish the installation
- You can always open the plugin from your excel sheet by going to Insert > My Add-ins > Excel to SMS
3. Excel sms Plugin-Login To Bulk SMS Login
The first time you use Excel to SMS, you need to connect Excel to Textlocal account using an API key. You can find the API key here:
- Click Settings > All settings > Excel Plugin
- Click on Create New Key
- In the Notes field, give your API key a recognisable name, for example; Excel. Click Save New Key
Your API key will be an alphanumeric string in the formatXXXvIElXXnvha4FWmXXX5HMOBON5IuGuXXX16XXXX
When you first install the plug in, you will be prompted to add your API key in to the Textlocal window in Excel.
Click Enter to connect Excel to your Textlocal account.
4. Excel sms Plugin – Compose your message
You can start writing your message once you have installed the Excel plug-in and input your API key.
Excel sms Plugin – Configure Sender IDs
Note: If your account is in promotional route, the messages will be sent with a random 6 digit Sender IDs assigned by the operator. Upgrade to transactional route in order to receive a Sender ID of your choice. (Be aware of the distinctions between transactional and promotional messages here)
You can ask for a Sender ID of your choosing with six alpha characters after upgrading to the transactional route. Once approved, when you open your Excel file again, you can choose the Sender Names from the drop-down list labelled “Sender Name.”
You can use existing data from the Excel sheet to form the message content and contacts. Alternatively, you can manually type the message content and contact numbers in the plugin window.
Excel sms Plugin – Manual messages
To manually create messages, set ‘Use Selected Cells’ to No. Select Compose Message and type your message in the pop-up window. When your message is ready, click Save.
Next, manually add your phone numbers into the Numbers field. You need to press ‘Enter’ or ‘,’ after entering each number – you will see that the number turns blue once it has been accepted into the system.
You can send this message to as many numbers are you want and every recipient will receive the same message; no personalisation can be applied with this method.
Excel sms Plugin – Automated messages
If you want to personalise your messages, select the cells you want to use in your message, set Use Selected Cells to Yes and confirm your selection by clicking OK in the pop-up box.
Select Compose Message.
When you want to add personalised content into your messages, use the columns drop-down menu to select the information you want to add to your message then click Insert Placeholder.
You can also add in personalised information without using the drop-down menu, by typing the column header in { } brackets, e.g. {Pet} is due a {Treatment}. If you use this option, you MUST observe the same spelling, spacing and capitalising as in your column headers.
When your message is ready, click Save.
Next, you must tell Excel to SMS which of your columns contains your phone numbers. Use the Numbers column drop-down menu to do this.
Excel sms Plugin – Scheduling messages
Use the Date and Time field to schedule your message send. if you want to send your message ‘now’, you must schedule it to go out in one or two minutes.
5. Send your message
When you hit Send you will see a summary of your message.
This window will show you the content of your message and the Number of Messages you are sending (this is the number of contacts you are sending to, NOT the number of 160-character SMS credits you are using). You can also review the Date and Time scheduled for your send.
The Calculate Cost function shows you the number of SMS credits that your send will consume (1 credit = 160 characters).
To send your message, click HERE.
