none
how to send SMS using with API link form ms access Form.. RRS feed

  • Question

  • Sir

    i am trying to send SMS  using with API  link, So While i mention Cell number and Massage in that link directly it was successful.

    But When i replaced with object in place of Cell number and massage in API Link it was not working, see what i did ..   

    Sub SendSMS()
        Dim appIE As Object                               
        Dim strURL As String

        Set appIE = CreateObject("InternetExplorer.Application")

        strURL = "http://sms.hspsms.com:/sendSMS?username=demo&message=" & me.massage.value & "sendername=" & WENKKET & "smstype=TRANS&numbers=" & me.number.value & "apikey=df455d38-e36d-4f6f-acc7-261eeb33f337"

        With appIE
            .Navigate strURL
        End With
        Do While appIE.busy
            DoEvents
        Loop

        appIE.Quit

    End Sub

    //////////

    pls. find the database file link what i did..

    https://drive.google.com/open?id=0B3t4kDZkt9nAbFVSUFVYYURsbmM

    Pls. help me...


    • Edited by Wenkket Wednesday, August 26, 2015 3:49 PM
    • Moved by Youjun Tang Thursday, August 27, 2015 8:14 AM more appropriate
    Wednesday, August 26, 2015 3:39 PM

All replies

  • Hi Wenkket,

    As your issue is related to VBA, It is not winforms issue, I'll move the post to VBA forum for help, thanks for your understanding.

    Regards,
    Youjun Tang


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, August 27, 2015 8:13 AM