If you are getting the following Error while send SMS from SMSCountry Excel Plugin "Application-defined or object-defined error" then please perform the following checks to resolve this issue.
Every Excel Sheet has got a unique Identity for every column as its column heading ex: A B C ... till ZZ.Inorder for us to specify column name in our excel software, we have used #A# instead of just specifying A to differentiate it from normal english characters. Since # is used by us as reserved character, issue arises when your message also as # in it.

Cause Of Error :-
The above picture shows you error which might occur when you are using #(hash) character in your message.
Solution :-
Please try sending SMS after removing # character from SMS Message...
Ex:-(Below message gives you error in Excel Plugin as Application-defined or object-defined error since there is # repeated in your message too.)
Dear #B#
Your Account # is #C#
Your Balance is #D#
To resolve the erroe you can edit message as.
Ex:-
Dear #B#
Your Account No. is #C#
Your Balance is #D#

I have removed # character from message and it works fine. As shown in above image.
That's it for this topic. If still that doesn't help then let me know so that I can give you some more solutions for it.

No comments:
Post a Comment