sending sms from excel vba

Hi all.
You will find attached a vba code for sending sms.
it runs normally but does not deliver sms.
Someone to help me figure out what is missing please

Please Login or Register  to view this content.

What are you trying to do with this line of code:

Please Login or Register  to view this content.

It is setting Recipient to the string "x&lastrownumber" which is probably not a valid recipient string. Is it supposed to getting a phone number from a cell? At first I thought you meant this:

Please Login or Register  to view this content.

but there is no variable lastrownumber. Could you possibly mean this?

Please Login or Register  to view this content.

Also I don't believe this runs because this line does not compile:

Please Login or Register  to view this content.

Do you mean this?

Please Login or Register  to view this content.

Thank for your reply

I retrieve the telephone number in the "lastrownumber" cell then concatenate it with the code of my country "x"

you're right, it's rownumber.
I corrected and replaced the + by & in the API but it is doesn't work

The message has embedded spaces. This is not legal in a URL.

Please Login or Register  to view this content.

Spaces must be converted to %20 in a URL. Do this after the URL is complete:

Please Login or Register  to view this content.

I am still getting automation error with your code, still trying to figure out what else is wrong.

OK, thanks.
I'm also looking on my side.

Thank you for your contribution. I was able to send the messages as well. Really, thank you.

However, without asking too much, I have another provider that offers me more benefit. So, I would like to replace the previous url with this one.

app.techsoft-web-agency.com/sms/api?action=send-sms&api_key=Um9kcnlnMTIzOnNhbG9tZQ==&to=PhoneNumber&from=SenderID&sms=YourMessage&unicode=1[/url]

Please what should I modify for its configuration

I have to cut the first part of the url because I am not allowed to post the links

This is how I configured the new url according to the documentation I found on their site.
But at the line "objWinHTTP.Open" GET ", URL & Request, False" I am told that the url uses an unrecognized protocol

Please Login or Register  to view this content.

Thanks Experts!