• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Send SMS Excel vba

David_4512

New Member
Hello. I have this API for sending SMS. The text is in Unicode.


RETURN CODE VALUES
------------------
0000 - Operation successful
0001 - Internal error (wrong IP)
0003 - Invalid request
0005 - Empty message
0007 - MSISDN error (wrong Phone Number)
0009 - Not Allowed

The numbers are in column A. The text is in column B. I want to send the number in cell A1 to the text in cell B1. And so on. I want to show the result in column C.

Username [username] is I1. pass [password] is i2

I tried ChatGPT, it helped me, but this code doesn't work

In cell C it writes an unknown error and for example, number 10 is recorded and sends to the number in the last cell only. And writes an unknown error in cell C


 
"SMS", that's text messaging on a cell phone, right? If so, something above isn't right; you said you want to send the number in column A to the text in column B, but surely you meant the other way around? The target's cell-phone number is in col A, and you want to send the text in col B to that number?
 
Back
Top