(Excel) SMSAPI - Send SMS with Multiple Lines of Text

See more SMSAPI Examples

Send an SMS message containing multiple lines of text.

For more information, see https://www.smsapi.com/docs/#2-single-sms

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Implements the following CURL command:

' curl -H "Authorization: Bearer token_api_oauth" \
' "https://api.smsapi.com/sms.do?from=sender_name&to=44123456789&message=message_content&format=json"

' Use the following online tool to generate HTTP code from a CURL command
' Convert a cURL Command to HTTP Source Code

' Adds the "Authorization: Bearer token_api_oauth" header.
http.AuthToken = "token_api_oauth"


messageContent = "Hello" & vbCrLf & "This is a test" & vbCrLf & "with multiple lines of text."

' Given that our message contentn has newlines, we obviously cannot put newlines in a URL without them being URL encoded..
' Therefore.. URL encode..
Dim sbMessage As Chilkat.StringBuilder
Set sbMessage = Chilkat.NewStringBuilder
Dim success As Boolean
success = sbMessage.Append(messageContent)
success = sbMessage.Encode("url","utf-8")

success = http.SetUrlVar("msgContent",sbMessage.GetAsString())

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = http.QuickGetSb("https://api.smsapi.com/sms.do?from=sender_name&to=44123456789&message={$msgContent}&format=json",sbResponseBody)
If (success = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response body:"
Debug.Print sbResponseBody.GetAsString()