如何从Ms Access发送和接收短信(SMS)

我希望能够使用VBA代码从Ms access表格发送一些SMS文本(短消息系统),请参见如何修改以下代码。我已经与手机服务提供商就条款和条件达成了一致,这就是为什么我需要正确获得VBA的原因。

Private Sub CmdSmsLines_Click()
  Dim strURL As String
  Dim neMb As String
  Dim msGe As String
  Dim appIE As Object

    Set appIE = CreateObject("InternetExplorer.Application")
    neMb = Me.txtneMb.Value
    msGe = Me.txtmsGe.Value


    strURL = "http://Christkool.com/api/XXXXX=success&pass=RRRRR&sender=ZZZZZ=" & neMb & "text=" & msGe & "priority=ndnd&stype = normal"


   With appIE
        .Navigate strURL
        ' uncomment the line below if you want to watch the code execute,or for debugging
        '.Visible = True

    End With
    ' loop until the page finishes loading
    Do While appIE.busy
        DoEvents
    Loop

    appIE.Quit
End Sub
zb415 回答:如何从Ms Access发送和接收短信(SMS)

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/3153913.html

大家都在问