1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| Private Sub BtnSend_Click()
'reference Microsoft Forms 2.0 Object Library doit être ajoutée
Dim mainURL As String
Dim finalURL As String
Dim objXML As Object
Dim strResponse As String
Dim Username As String, Password As String, Account As String, Recipient As String, Body As String
'fill your data HERE
'Username = "UsernameEssendex"
Username = Form_F_SMS.Username.Value
'Password = "Password Esendex"
Password = Form_F_SMS.Password.Value
'Account = "AccountEsendex"
Account = Form_F_SMS.Account.Value
'Recipient = "N° Tel"
Recipient = Form_F_SMS.Recipient.Value
'Body = "Message"
Body = Form_F_SMS.Body.Value
'mainURL
mainURL = "https://www.esendex.com/secure/messenger/formpost/SendSMS.aspx?"
'build URL - ne pas modifier
finalURL = mainURL & "username=" & Username & "&password=" & Password & "&account=" & Account & "&recipient=" & Recipient & "&body=" & Body & " &plaintext=1"
'set Post Url Object
Set objXML = CreateObject("MSXML2.XMLHTTP")
'open post url process
objXML.Open "POST", finalURL, False
'send message request
objXML.send
'retrieve response
strResponse = objXML.responseText
'display response (messageID)
MsgBox strResponse
'Ferme le Formulaire SMS
DoCmd.Close acForm, "F_SMS"
End Sub |
Partager