16. INDIA BulkSms Excel Plugin User Manual
Contents
1. welcome to Bulk Sms Excel Sms Dummy Welcome to BulkSms Excel Sms Sheet2 919812345695 Welcome to BulkSms Excel Sms Sheet3 919312345699 Welcome to BulkSms Excel Sms Adobe 919812345675 to Bulk Sms Excel Sms Acrobat 919812345681 Welcome to Bulk Sms Excel Sms Word 919312345652 919312345655 919812345686 Welcome to BulkSms Excel Sms SOL Welcome to BulkSms Excel Sms Outlook VWrelcome to BulkSms Excel Sms Access 1 Preview of messages and mobile numbers to whom messages will be sent amp Total number of messages Total number of messages to be send and Invalid Messages found from total number of messages whenever range is selected for messages to be sent 2 After clicking continues button messages will be sent to the list previewed 3 Cancel button will cancel the process and get back to the send Sms form GLOBAL LEADER IN MOBILE MESSAGING routesms essaging amp Voice API Company gt 5 4 Scheduling of Messages After user has filled all the fields properly but user want to send these later then user can schedule the messages as with date and time specifications by clicking schedule button When user click schedule button a form will open which is shown as sa Schedule Bulk Message 971772011 3 04 51 PM 2 E i Tes a de ee N 1 Select the time zone which user will prefer 2 Select the Date on which you want to schedule it 3 S2. gt coutesms 7 2 Sms Report Sms Report displays the detailed information of all sent sms and price charged along with delivery status for selected date range User can search for a particular mobile number sender or message details by adding search filters User can also export sms report in comma separated value format csv Search Category Mobile Number Sender Message Status Date From 2011 03 01 atata E Search 7 SMS Reports A Q Export No Mobile Message Type iLenat nisender Credit Deducted Status Date E I l ae nn oe EE _ amt d 4 dsfsfsdf Text 19 11234567891 23456783 1XXXXE UNKNOWN 2011 05 16 21 21 00 43543543534 dsfsfsdf Test 8 1123456789123456789 LXXX UNKNOWN 2011 05 16 21 21 00 L mnd hehe dl REED NEBEN Fret Previous a Next Last Goto Page Number Page 1 of1 Total Records Found 2 a 1 Enter Mobile Number 2 Enter Sender 3 Enter Message details 4 Select Delivery Status 5 Select Start Date 6 Select End Date 7 Click here to get the details of the specified data 8 Click here to download report in csv format 9 Click here to refresh 7 3 Sms Summary ma GLOBAL LEADER IN MOBILE MESSAGING gt routesms SS Sms Summary displays the date wise sent sms count and total price charged along with country operator details for selected date range User can also view sum
3. When user send the personalized unicode message it will get converted into unicode message and will be shown in preview as D Preview Total Messages 20 Messages to be Sent 18 Invalid Numbers 2 0054006500730074006S006E 006700200000 00040 0054006500730074006S006E 006700200000 00040 0054005500730074006S006E 00670020000000040 _ 00540065007300740053006E 006700200000 00040 300740053006E 006700200000 00040 00540065007 300740053006E 006700200000 00040 00540065007 300740063006E 006700200000 00040 0054006500730074006S006E 006700200000 000A0 00540065007 300740053006E 006700200000 00040 00540065007 3007400653006 006700200000 00040 00540065007 3007 40053006E 006700200000 00040 00540065007 300740053006E 006700200000 00040 00540065007 230074005300SE 006700200000 00040 1 Total number of messages Total number of messages to be send and number of Invalid Messages found from total number of messages whenever personalized Unicode messages to be sent 2 Preview of phone numbers and converted Unicode messages to be sent 3 After clicking continues button messages will be sent to the list previewed 4 Cancel button will cancel the process and get back to the send sms form GSMA Associate Member GLOBAL LEADER IN MOBILE MESSAGING Ba routesms A Messaging B Voice API Company 6 JOB MANAGEMENT Job Management option displays details of the jobs
4. 4 e g Welcome to BulkSms Excel Sms B means WelcoBulkSmseExceltoSms will be send to message written in column B of the Excel sheet in frontof mobile number against that message is written 11 Only English Message is allowed for Text and Flash Message Type 12 Schedule button is used to schedule the message 13 Send button is used to send the messages to selected numbers it will show a preview of them 14 Cancel button will cancel the form and get back to the Excel worksheet 15 Reset button will reset all the fields to initial state as in form loaded 16 Template field GLOBAL LEADER IN MOBILE MESSAGING routesms A Messaging amp Voice API Company Welcome dind kedar Send SMS Personalise Sender Mobile No Add Field Rn al Numbers Type C E Text u me 2 n ed Range 1 Wait Processing Your Message will be Previewed s lar P G FROM Message Templates Welcome to BulkSms Excel Addin RBA J K L TO M N Unicode Converter Not Scheduled Schedule 1 A wait message will be shown til the preview window opens GSMA Associate Member routesms A Messaging amp Voice API Company Total Messages Messages to be Sent Invalid Mumbers Message 7 g1 Welc
5. IND BulkSms Menu Commands Al ep co sa fen fan te us ro lw il 13 14 RE Sheet tad Ready 1 User enters his her User Name 2 User enters his her password 3 User hits the Login button to login with the entered username and password A Cancel button to go back to Excel worksheet GSMA GLOBAL LEADER IN MOBILE MESSAGING WAON Associate Member routesms A Messaging amp Voice API Company 5 SEND SMS User can send messages using this tab 5 1 Send Text or Flash Sms Welcome dind kedar Send SMS Sender Type s gt m Text Flash 5 Unicode T Wap Push Selected Range zu 5 Message Templates Welcome to BllkSms Excel Addin B TO Schedule 1 Name of user is displayed 2 Select the Checkbox for Personalize Message 3 Enter senders name 4 Select column name from dropdown list in which mobiles numbers are written in Excel sheet 5 Select the column from list which has the messages in the sheet 6 Select the radio button for all the numbers in a column which ts selected in step 3 7 Select this if you want to select a specific range from sheet 8 Give details of range from and to e g Al C4 then the entire numbers from Alto C4 are selected for sending messages 9 Select the type of message as Text Flash or Unicode 10 Type the message to send to all with message field selected in step
6. Program Files IND BulkSms IND Bulk me Don t change the path specified for Stall IND Bulk Sms for yourself or for anyone who uses this computer installing setup J Evervone 9 Just me GSMA Associate Member GLOBAL LEADER IN MOBILE MESSAGING aa routesms essaging amp Voice API Company Confirm Installation The installer is ready to install IND BulkSms on your computer Click Next to start the installation GLOBAL LEADER IN MOBILE MESSAGING Member routesms A Messaging amp Voice API Company t IND BulkSms Installing IND BulkSms IND BulkSms is being installed Please wait Installation Complete INO BulkSmes has been successfully installed Chick Clase bo exit Please use Windows Update to check for any critical updates to the MET Framework i GSMA ay Associate Member ia GLOBAL LEADER IN MOBILE MESSAGING routesms A Messaging amp Voice API Company 3 Add Ins The BulkSms Excel Add In in Excel is shown below Page Layout Formulas ze Insert F Delete fe Som amp Find amp 0 00 tt io Format 7 fh Filter Select Number Ta Cells Editing sa 3 4 5 D B 9 4 4 K N Ready GLOBAL LEADER IN MOBILE MESSAGING 0 gt routesms A Messaging amp V
7. f G Message Templates Welcome to Buk Sns Excel Addin ABH H L M N s Not Schedule 1 When user select the Select Range radio button then and To will enabled and Mobile Number dro can write message or set it in any form and after this user can schedule or send the message Range A1 A17 means this will select all the numbers which comes in the fields from cell A1 till A17 After user select to send the message first all the duplicates have been removed from list and final list shown as shown in the next screen shot GLOBAL LEADER IN MOBILE MESSAGING GSMA Associate Member Ba routesms A Messaging amp Voice API Company 5 3 Selected Range Preview List After user hits the send button then all the duplicate entries are removed means an mobile no with same message entered into the worksheet then only one entry will be considered for sending and an preview will be shown as between the selected range of cells of worksheet Preview Joe Total Messages Messages to be Sent Invalid Numbers hMobileNpimber Message 919312345678 Welcome to BulkSms Excel Sms tester 919312345679 Welcome to BulkSms Excel Sms Test 919312345650 Welcome to BulkSms Excel Sms SmsPlus 919812345681 Welcome to BulkSms Excel Sms Excel 919312345652 Welcome to BulkSms Excel Sms Microsoft 919812345683 Welcome to BulkSms Excel Sms Book 919312345654 919812345678
8. uploaded by the user from Send Sms L Search Category i ll T Date Fig Det 717 R Manage Scheduled Job IES Search By A Total Destinatior Schedule Time OOo T 0000 00 00 00 STOPPED 0000000 00 STOF PED 0000 00 00 00 iN PROCESS _ 2011 05 08 17 STOPPED 2011 05 08 17 STOPPED M routesms A Messaging B Voice API Company Job Mansgement Search Categor Message Date From zn 3 1 Manage Scheduled Job Search By jan Messegetencth Sent Total Destinsion Schedule Time Status T3 3 2011 07 26 170 SCHEDULED Total No of F 0 0 n w 0 g CE IN PROCESS 0 201 1 05 08 17 STOPPED o 1 201 1 05 0817 STOPPED x v lt Total No of Records 39 routesms A Messaging amp Voice API Company Search Categor Message laeda Daefom 7 13 2011 2 DateTo E _ Manage Scheduled Job en Search By SCHEDULED Te Select Message Sender Message Type_ Message B PARA uwe Unicode 17 2 y U testing tat2unewe Unicode 28 B i testing tt unwe Unicode 128 1 C testing _tet2uniwe Unicode 28 18 f D tet2ardek Unicode 17 10 L ab Are you sure to delete this Job G 7 m eat p f A 2 x KA h J ana mh es whee bh a a F 7 NG routesms A Messaging amp Voice API Company Search Jor Messes
9. 406270646062406420627064406440020 1 Select type of message which can be converted into a Unicode message i e Normal or Arabic Enter text of message to convert into a Unicode message Shows the number of messages Shows the number of characters in a message Shows the converted Unicode message when user hits the convert button 6 Shows the length of the Unicode message 7 When user hits the convert button written message get converted into Unicode message amp shown in step 5 8 Reset button reset every field to initial stage 9 When user hits the set as message button then Unicode message is send to the message field of send message form as shown in next step uBR WN zz GLOBAL LEADER IN MOBILE MESSAGING routesms A Messaging amp Voice API Company 5 7 Unicode Message GLOBAL LEADER IN MOBILE MESSAGING After an message is converted into unicode form Welcome dind kedar Send SMS Personalise Sender Mobile No Add Field 022754 x A all Numbers Type c 7 F Text Flash Unicode Wap Push D Selected Range F G FROM Message Templates i 4 h TO M In Number Of Characters 128 Not Schedule Schedule 1 Message after it is converted into Unicode message from Unicode converter and button Set As Message is hitted by user And schedule this for sending In this Number of characters in total is also Shown Associat
10. 48 18 DELETED 2011 06 08 11 48 18 ai GLOBAL LEADER IN MOBIEE MESSAGING routesms A Messaging amp Voice API Company 10 About Us Will display Details of User Company gt Home Insert Page Layout Formulas Data Review View Add Ins Team O w Userlogin Send SMS Job Management Reports User Profile 4 ja g ILA a G Coverage Details About us Proxy Settings routesms A Messaging amp Voice API Company won an uw Copyrights RouteSms Solutions Limited Associate t Member es B GLOBAL LEADER IN MOBILE MESSAG
11. User Manual IND BulkSms Excel Add In routesms Messaging amp Voice API Company Contents E COV CRN W tiavissaessstescicosssesaveeesttsasssisacausseusewersts 3 2 Steps tO run an Excel Add In Setup sack 4 SHE E E EE EEEE 11 4 LOG I ren een een en erneuern 12 INV L rcs ca eis E E 13 CI R L a Or SI SUNG gpa azn en ee u ee een 13 3 2 CC Oe ee nee 16 II Schker E BH 374 CMC UNS OLIN CSSA T 18 33 CMCC UICC Te nenne een 19 DA MICOS OTN CS TTT 20 6 21 5 8 Personalized Unicode Message p 22 5 9 Previewing Personalized Unicode Message sss esse 23 JOB 24 TPO k TETE 28 eM e lt T E 1 T 28 72 STEREO TTT 29 1 3 S108 S seen ee re ee ee 30 USER PROFILE 2er innen 31 9 COVERAGE DETAILS uses 35 1 KM 4 1131 11 18 T 36 GLOBAL LEADER IN MOBILE MESSAGING routesms essaging amp Voice API Company 1 Overview The proposed system serves as a solution to add the Add Ins to MS Excel 2003 and MS Excel 2007 with the name BulkSms Excel which allows the user to send sms to list of Mobile Numbers with specified messages which are present in an Excel sheet When user is using this system user can send sms to specified range of mobile numbers present in different columns of worksheet In this system user can send messages in the form of Unicode messages amp flash messages Here user is provided with the facility of converting a message to Unicode form and user can write an Arabic message
12. confirm new password Enter the company name Enter the contact person name in the company Enter the mobile number for the contact person Enter the valid email id for the contact person or company 0 Click here to save the updated User Details BOON OU 5 LU N kA fs GLEOBALZSEEADER ZENZSMOBTE FF See as 5 5 Associate SS ee rn SS D _ gt D r E LT ee eee T n u rs x Fa m Pw Pa RHH HT PN o i 9 COVERAGE DETAILS Coverage Details provides the coverage information of the user User can view the default price the assigned pricing and the special prefix pricing Coverage Detalis Of Default Price Assigned Pricing Special Prefix Pricing nl GLOBAL LEADER IN MOBIEE MESSAGING routesms A Messaging amp Voice API Company GLOBAL LEADE 2 SS e e l Li User can also view the last seven days routing changed logs and special prefix pricing changed logs Routing Change Log pip Te Li i ee ip al Country IS d Price New Price Status Date South Africa UPDATED 1201 1 06 08 11 United Kingadom G I J ELLI CERA DELETED 2011 06 08 1 UPDATED 2011 08 08 1 UK Orange U ee oe oe U DELETED 201 1 06 08 1 Master Routing Change Log Country Operator Old Price IN ew Price G Status ie ate Spain vodafone DEAA pO ee UPDATED 2011 06 08 11
13. e Member a S Ba routesms essaging amp Voice API Company 5 8 Personalized Unicode Message If user want to send Personalized Unicode Message then user has to select Unicode Type and in the Message add Fields of Excel which contains message to be sent Welcome dind kedar Send SMS Personalise J Sender Mobile No Add Field A B All Numbers Type C Text gt Flash Unicode Wap Push Cu O Selected Range u G FROM Message Templates 8C 0074006500730074006S006E006 700 J 20000D000400420075006C 0068002000 K TO 53006D0073000D000A004500 L 65006C0020000D000A004 100640 gt L kd f Unicode Converter Scheduler Not Schedule Send Cancel 1 Select Unicode Radio button which will open new Window where one can type required characters of message in any language which gets converted to Unicode format and set as Message shown in Step 2 2 Message field will display the Unicode message and selected tags while sending messages in Unicode form Then either we can schedule these messages or send directly 3 Unicode Converter button when clicked Unicode converter window will get opened where user can type required characters of message in any language which gets converted to Unicode format and then set it as Unicode Message 3 GLOBAL LEADER IN MOBILE MESSAGING Be W routesms A Messaging amp Voice API Company 5 9 Previewing Personalized Unicode Message
14. elect the time Note that time should be greater than current time 4 Ok button will set the schedule amp a message box is shown as you press Ok then Schedule will be displayed on the send Sms page as we show in next picture 5 Reset button will reset all the fields to initial state GLOBAL LEADER IN M routesms A Messaging amp Voice API Company 5 5 Scheduled Message Welcome lt The Message is scheduled as shown below z dind kedar Send SMS Personalise Sender Mobile No Add Field la al I bie a Text C1 Flash Unicode Wap Push Selected Range E Message Templates 4 Welcome to Bulk Sms Excel Addin ABA 4 K L TO hl d Schech jer Schedule to send at 10 20 2015 3 24 PM at 5 30 1 Displays the scheduled Time Date and Time Zone that user had selected during scheduling GLOBAL LEADER IN MOBILE MESSAGING routesms A Messaging amp Voice API Company 5 6 Unicode Converter When we select the radio button Unicode type then this form will open as Boe a Unicode Message Urecode Converter C 7 Normal Message Arabic Messsage Type Arabic Message E BOSS r lonk 5 ESS das iws olas ew Gb oie IIE GS eeo hal Be LESS 9S Su eT Se INOS Ses bs Ewe SE Ses J JE ae SEM SNS Js SHS eT de Ko No Of Characters 62 i 063006270641 06440020064206 31 0628002006330531 06 0645062700200623063390644064500200631 06260544 0645062C0644063300200627064
15. i Sede Cf pae Phan 7 13 2011 IS Date To Search M anage Search By PROCESS A Select Message Sender Message Type Message tength Sent C hi lt tagt gt fa seh Text amit Unicode amit Unicode amit 4 amit amit Are you sure to STOP this Job S vent Ma Member routesms A Messaging amp Voice API Company 7 REPORTS Reports enables user to view details of messages sent by User and delivery status of sent messages along with detailed credit usage and current day for the users gt Credit Details Sms Reports Sms Summary 7 1 Credit Details Credit Detail report displays the current credit balance and the outstanding Over Draft It also displays the credit change log for the selected time interval To get the credit change log details select the Start and End Date and then click Search buttc Credit Details SMS Reports SMS Summary 3 Credit Status En L Search Categor gt aii x J A Outstanding Overdraft EUR 0 00000 Date From 8 1 2011 wi Credit Balance EUR 0 25500 Date To 9 13 2011 HT Credit Details 2011 09 07 19 16 00000 0 00000 0 25500 0 00000 2011 08 23 17 10 00000 0 00000 20 00000 0 00000 2011 08 1211 11000000 0 00000 1000000 000000 loial No of Records 3 First EZ gt gt J GSMA Associate Member GLOBAL LEADER IN MOBILE MESSAGING routesms A Messaging amp Voice API Company
16. mary for particular country and operator by selecting them depending on user preference Search Category 2011 05 31 Search Summary Reports S R ountrv per Lor Message ne55ao0e M narge ie O prec ETO 3 India ri 1 05 14 Trevis Nex Lest Pa Page 1 of1 Total Records Found 1 Select country 2 Select operator 3 Select Start Date 4 Select End Date 5 Click here to arrange by date country and operator 6 Click here to get the details of the specified data 7 Click here to refresh all GLOBAL LEADER IN MOBIEE MESSAGING outesms A Messaging amp Voice API Company 8 USER PROFILE User Profile enables to modify user details like password company contact person contact number and email id All the details are mandatory To change password click the checkbox beside the new password field as shown below User Profile J l UserName stand 3 c 3 Password A 4 L New Password 27 E Confirm New Password L ae Company E En Contact Person jamit 9 Mobile Number 3933453421 a NEE Emaild test tester com ie This displays the username for the logged in user Enter password required for validation of the user Click the Check box to change the password If password has to be changed the click the checkbox and enter New Password Re type the new password to
17. oice API Company doo kT Microsoft Exce Home Insert Page Layout Formulas Data Review View Add Ins Team w M X IND BulkSms Menu Commands 2 ee T lao pa w le ae lu lM ke EGE Z k fa ww 44 gt Sheetl fd rr ee Ready E 100 1 After we run the setup a tab will appear like this 2 After clicking the Add Ins tab IND BulkSms tab will get open on left upper corner Associate Member GLOBAL LEADER IN MOBILE MESSAGING A Messaging amp Voice API Company i routesms Wicrosott ce Home Insert Page Layout Formulas Data Review View Add Ins Team UserLogin Send SM5 Job Management Reports Ce 2 User Profile Lc p Ee F e u i I k Coverage Details About us Proxy Settings N 4 K Sheeti 2 i I Ready FL rg 1 After clicking the IND BulkSms tab all the menu buttons get open a User Login b Send SMS c Job Management d Reports e User Profile f Coverage Details g About us h Proxy Settings GSMA Associate Member GLOBAL LEADER IN MOBILE MESSAGING _ WAON routesms A Messaging amp Voice API Company User can login with the username and password Ox m W lt ra ka J FOORE Wicrosott cel F D x i Home Insert Page Layout Formulas Data Review View Add Ins Team 7 M X
18. ome to BulkSms Excel Sms tester EEE Jorg Naa e Tre fo Buk Sins Erce Sme Test 91981 2345680 Welcome to BulkSms Excel Sms SmsPhus 391981 2345681 Welcome to Bulk Sms Excel Sms Excel 919912245682 NAP ebu bo B dk Sms Excel Sme Microsoft 919812345683 W eline bo Bulk Sine Excel Sme Book 91981 2345684 welcome to Buk Sms Excel Sms Diummyi 919812345676 Welcome to BulkSms Excel Sms Sheet 91981 2345698 Wreloome to BulkSms Excel Sms Sheet3 sige 2345699 welcome to BulkSms Excel Sms Adobe 9193812245678 Welcome to BulkSms Excel Sms Acrobat l 919912345691 e ehcrre Ron PLAS ss Excel Sms Bc ord 9198912345682 WwWelcome to Bulk Sime Excel Sms Outlook l 91981 JH See NAP ehr goure to Buk Sme Ecel Sma ACCESS 91981 2245556 Welcome bo Bulk Sins Excel Sms SOL i ar 1 Preview of messages and mobile numbers to whom messages will be sent amp Total number of messages Total number of messages to be send and Invalid Numbers found from total number of messages 2 After clicking continues button messages will be sent to the list previewed 3 Cancel button will cancel the process and get back to the send sms form GSMA Associate Member GLOBAL LEADER IN MOBILE MESSAGING routesms A Messaging amp Voice API Company 5 2 Select Range Welcome dind kedar Send SMS Personalise Sender Mobile No Add Field Z mn a A All Numbers IC L Text Flash Unicode Wap Push E E 9 Selected Range
19. too This system provides the facility of scheduling of messages i e when to send the messages to specified mobile numbers user can specify the time and date for scheduling In this system user can view the JobreportsManagement for Reports User Profile and Coverage Details for login user GLOBAL LEADER IN MOBILE MESSAGING BE Messaging amp Voice API Company 2 Steps to run an Excel Add In Setup 1 Click the first exe File Setup Then one will see the installation 2 First it will ask to install 3 to 4 components that are required for excel routesms interface add in to run 3 Then Follow the below steps Welcome to the IND Bulks3ms Setup Vizard The installer wall guide you through the steps required to install IND EBulESms on your computer MM AH NIN D Thi computer program ts protected by copyright law and international treaties Unauthorized duplication or distribution of this program or any portion of it may result in severe civil or criminal penalties and will be prosecuted to the masimum estent possible under the lav Cancel BE Si S GLOBAL LEADER IN MOBILE MESSAGING routesms essaging amp Voice API Company Select Installation Folder The installer vill install IHD Bulk Sms to the following folder To install in this folder click Nest To install to a different folder enter it below or click Browse Folder C
Download Pdf Manuals
Related Search