Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20

Procedure to send group SMS

This is a discussion on Procedure to send group SMS within the Excel Questions forums, part of the Question Forums category; Here in india leading mobile operator is : - Airtel(Bharti Group),Bearer : -Airtelgprs.com However i want the solution using web ...

  1. #11
    Board Regular Sachin2k6's Avatar
    Join Date
    Mar 2012
    Location
    India
    Posts
    349

    Default Re: Procedure to send group SMS

    Here in india leading mobile operator is : -

    Airtel(Bharti Group),Bearer : -Airtelgprs.com

    However i want the solution using web service of sending SMS, for example fullonsms.com .
    I use Excel 2007 with Windows xp .

  2. #12
    Board Regular Kyle123's Avatar
    Join Date
    Jan 2012
    Location
    Leeds, UK
    Posts
    1,120

    Default Re: Procedure to send group SMS

    Then ideally you'll need to find a webservice to do this - fullonsms is a website and as far as I can see doesn't offer a webservice

  3. #13
    Board Regular Sachin2k6's Avatar
    Join Date
    Mar 2012
    Location
    India
    Posts
    349

    Default Re: Procedure to send group SMS

    Quote Originally Posted by Kyle123 View Post
    Then ideally you'll need to find a webservice to do this - fullonsms is a website and as far as I can see doesn't offer a webservice
    You are right fullonsms is a website providing free SMS facility. I want to send SMS through this website.
    I use Excel 2007 with Windows xp .

  4. #14
    Board Regular Kyle123's Avatar
    Join Date
    Jan 2012
    Location
    Leeds, UK
    Posts
    1,120

    Default Re: Procedure to send group SMS

    It would be much easier if you found a website offering a webservice

  5. #15
    Board Regular Sachin2k6's Avatar
    Join Date
    Mar 2012
    Location
    India
    Posts
    349

    Default Re: Procedure to send group SMS

    Can you suggest any one?
    I use Excel 2007 with Windows xp .

  6. #16
    Board Regular Kyle123's Avatar
    Join Date
    Jan 2012
    Location
    Leeds, UK
    Posts
    1,120

    Default Re: Procedure to send group SMS

    Not for India, I suggest you have a scout around

  7. #17
    Board Regular Sachin2k6's Avatar
    Join Date
    Mar 2012
    Location
    India
    Posts
    349

    Default Re: Procedure to send group SMS

    I have prewritten SMS Text in cell A1 and the No. of 10 employees in column B (B1:B10).

    Now how to put these values in the appropriates fields of the site 'fullonsms.com' and then trigger the send button by VBA Code. Assuming i have logged in on the site.
    I use Excel 2007 with Windows xp .

  8. #18
    Board Regular Sachin2k6's Avatar
    Join Date
    Mar 2012
    Location
    India
    Posts
    349

    Default Re: Procedure to send group SMS

    After a long search in forum, with the help of found codes i write the following code and login successfully on the site 160by2.com

    Sub Test()


    Const cURL = "http:\\www.160by2.com"
    Const cUsername = "XXXXX" 'REPLACE XXXX WITH YOUR USER NAME
    Const cPassword = "YYYYY" 'REPLACE YYYY WITH YOUR PASSWORD

    Dim IE As InternetExplorer
    Dim doc As HTMLDocument
    Dim LoginForm As HTMLFormElement
    Dim UserNameInputBox As HTMLInputElement
    Dim PasswordInputBox As HTMLInputElement
    Dim SignInButton As HTMLInputButtonElement
    Dim HTMLelement As IHTMLElement

    Set IE = New InternetExplorer

    IE.Visible = True
    IE.navigate cURL

    'Wait for initial page to load

    Do While IE.readyState <> READYSTATE_COMPLETE Or IE.Busy: DoEvents: Loop

    Set doc = IE.document

    'Get the only form on the page

    Set LoginForm = doc.forms(0)

    'Get the User Name textbox and populate it

    Set UserNameInputBox = LoginForm.elements("username")
    UserNameInputBox.Value = cUsername

    'Get the password textbox and populate it

    Set PasswordInputBox = LoginForm.elements("password")
    PasswordInputBox.Value = cPassword

    'Get the form input button and click it

    Set SignInButton = LoginForm.elements("button")
    SignInButton.Click

    'Wait for the new page to load

    Do While IE.readyState <> READYSTATE_COMPLETE Or IE.Busy: DoEvents: Loop


    'Login succeeded here.

    End Sub

    But to proceed further and access the send sms page i can't get the elements of the next page.

    How this code can be extended to access send sms page and send an sms to a particular number????
    Last edited by Sachin2k6; Sep 17th, 2012 at 02:44 AM.
    I use Excel 2007 with Windows xp .

  9. #19
    Board Regular Sachin2k6's Avatar
    Join Date
    Mar 2012
    Location
    India
    Posts
    349

    Default Re: Procedure to send group SMS

    ----------------
    I use Excel 2007 with Windows xp .

  10. #20
    Board Regular Sachin2k6's Avatar
    Join Date
    Mar 2012
    Location
    India
    Posts
    349

    Default Re: Procedure to send group SMS

    any one-----------
    I use Excel 2007 with Windows xp .

Page 2 of 2 FirstFirst 12

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com