In this tutorial I will show you, how you can send SMS messages directly from Microsoft Excel with VBA.

We will build a POST Request to sms77.io API using VBA.

Excel File of the tutorial [Google Drive]:
👉 https://bit.ly/3fliFTb​

If you want to send multiple messages, please use this workbook [Google Drive]:
👉 http://bit.ly/38r4IkD

🛑 The link to the API has been changed. You can create an API KEY now as follows:

https://pasteboard.co/JR3auFe.png ​

SMS77.IO Documentation: https://www.sms77.io/en/docs/gateway/…

🚩 VBA CODE:

Sub SendSMS()

'Authentication
APIKEY = “YOUR API KEY” ‘CHANGE HERE

'Variables
toNumber = = “RECEIVER NUMBER” ‘CHANGE HERE
BodyText = “TEXT MESSAGE” ‘CHANGE HERE
'Use XML HHTP
Set Request = CreateObject("MSXML2.ServerXMLHTTP.6.0")

'Specify URL
Url = "http://gateway.sms77.io/api/sms?p=​" & APIKEY & "&to=" & toNumber & "&text=" & BodyText & "&details=1"

'Open POST Request
Request.Open "POST", Url, False

'Request Header
Request.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"

'Send Request
Request.send Url

'[OPTIONAL] Get response text (result)
MsgBox Request.responseText

End Sub

Subscribe: https://www.youtube.com/channel/UCZjRcM1ukeciMZ7_fvzsezQ

#excel #excel-vba