+ Reply to Thread
Results 1 to 62 of 62

Vba to send sms to mobile number

  1. #1
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Vba to send sms to mobile number

    Hi everyone.

    I need help with little tricky problem.

    I need a macro code to send sms to few numbers everytime as and when i press the "PAID" button in sheet "INVOICE"

    SMS message can be "Hi you have made a sale to 'customer name' of 'amount'"

    Customer name refers to cell "C3" and amount refers to cell "Q42"

    I have attached my workbook.

    Is there any solution to it?
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Vba to send sms to mobile number

    It is not that simple. Sending SMS from a computer is not like email. Email works over the Internet but SMS requires access to the carriers' proprietary networks. This requires a third-party service that you are going to have to pay for. My company developed an application for the U.S. Department of Education that includes sending SMS for password resets and the government has a contract with a service to send these messages.

    If you find a service you like you can provide their published API here and we might be able to help interface it to VBA.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey Jeff,

    thanks for your help.

    Is there any other way to send any sort of message to a cell phone?

    Maybe through Whatsapp?

    Because by that I would be notified that a sale has been made.

    Any help?

  4. #4
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    Re: Vba to send sms to mobile number

    If a Quora comment is to be believed, that may get your whatsapp account suspended for a month.

    last comment here - I note because it is a risk to anyone testing this stuff (https://www.quora.com/How-can-I-send...tsApp-contacts)
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  5. #5
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey Jeff,

    I registered on a website for sending sms.

    Their website mentions this:

    "The url to be used is: http://www.smsidea.co.in/sendsms.aspx
    The variables to be used are:
    mobile : Your mobile number
    pass : Your Password/API Key
    senderid : Alphanumeric/Number SenderID
    to : Recipient Number
    msg : Actual Message to be sent
    msgtype : uc(Compulsary only for unicode messaging)


    Are these details good enough for us to work upon?

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Vba to send sms to mobile number

    That is not a tech spec to be able to write VBA. Can you refer me to the page where you got this information?

    I think VBA will be able to do this, either by telnet or a browser, but I have not done that type of interface so I may not be the right person to help. But I'll do what I can do.

  7. #7
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hi jeff,

    Sure.

    I have created a account on " http://www.smsidea.biz/ "
    They infact have an option to download the excel plugin.

    Do you want me to share the login details as well?

  8. #8
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey Jeff,

    Were you able to glance through?

  9. #9
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Vba to send sms to mobile number

    I don't need the login details. But you keep giving me generic information. I need specific technical specifications for how their interface works. I go to that site and can't find anything about an Excel plug-in.

  10. #10
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    After you enter that site, you need to login .

    After that, towards the left side , under Downloads, you will get the option to download the plugin.


    Here is the video which helped mu t understand how the site works.
    https://www.youtube.com/watch?v=cph2mLICx2g&t=165s
    Attached Images Attached Images

  11. #11
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Vba to send sms to mobile number

    The plug-in they provide takes care of the interface for you. Following their instructions you should be able to modify your data layout so you can use their plug-in without having to write custom VBA.

    There is no information here about how to write your own in VBA. If the plug-in is password-protected then I can't analyze their code to customize it.

    I guess that you are unable to find a complete technical specification that can be use to write custom code.

  12. #12
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    The problem is that I want to send a sms with a click of a button as soon as an invoice has been made.

    Thats why i thought VBA would be a good option.

    So basically through VBA,with a click of a button, I can send SMS.

    Here is something which I found on internet

    Please Login or Register  to view this content.
    Also something else which I found on internet which might help:
    https://stackoverflow.com/questions/...from-excel-vba

    Here is the API which i found on the website to send sms:

    sample HTTP API Call for Multiple Recipient would be: http://www.smsidea.co.in/sendsms.aspx?mobile=mobile number &pass=password&senderid=SMSBUZ&to=myrecipient1,myrecipient2,myrecipient3&msg=Your msg

  13. #13
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Vba to send sms to mobile number

    The code and sample HTTP call is helpful. I'll see what I can do with that.

  14. #14
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Sure,

    Thank you so much.

    I will try gathering few more information on it and get back to you

  15. #15
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Vba to send sms to mobile number

    I can't offer help with the actual coding but maybe this will help.

    You can send an email via VBA and as long as you know the provider of the cell phone, you can send an SMS via email.

    Let's say that my phone # is 123-456-7890 and that my carrier is AT&T. Sending an email to [email protected] will then send that SMS to my phone.

    List of gateway domains by carrier here:
    https://en.wikipedia.org/wiki/SMS_gateway

  16. #16
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Sure.

    Thank you so much for your response.

    I will try researching on internet and try coming up with a solution

  17. #17
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey Jeff,

    I got this document from the company.
    It contains information on how to do coding,
    I have attached the file.
    please do have a look
    Attached Files Attached Files

  18. #18
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    If sending bulk SMS via API. I'd generally recommend using something other than VBA. Since, VBA in itself is limited to single thread. Though you can get around this using external process/library, but it isn't ideal. I'd recommend using .NET, java or python. Utilizing async request processing.

    But check with your vendor, the limit on number of recipients in single request. If it's large enough, you can use VBA to build string and send request via xmlhttp using their http api.

    From the looks of the document, it doesn't use 2 factor authentication, and username & pass are hard coded in request being sent, so it is relatively simple to code for.

    As mentioned by 63falcondude, you could use SMTP to send SMS, using Phone# & SMS gateway. However, do note that you need to know the carrier each phone number belongs to before hand. Hence, why it is useful to have vendor with algorithm for bulk sending SMS (they usually have contract with carriers for this sort of thing).

    Let me see if I can dig up VBA code I wrote for simple API request, sometime ago.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  19. #19
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK,

    Thank you for your reply.
    The vendor allows me to send message to multiple users.
    They have provided sample coding as well.

    Thank you.

    Hopefully there is a solution

  20. #20
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    The vendor allows me to send message to multiple users.
    But what is the limit? Can you send to 100's, 1000's? What is your likely upper limit?

  21. #21
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK76,

    I am unable to fetch that information on their website.
    However in my case, I need to send sms to only 10 numbers at once.
    I will try getting the upper limit asap

  22. #22
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    Here's sample code construct. You'll need to adjust with actual headers etc required by the vendor.

    Please Login or Register  to view this content.

  23. #23
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK76,

    Thank you for puttin in your effort.

    I will try finding out what headers are needed from the vendors.

    I have edited the code . I got this error. I have attached the snapshot.

    Do you want me to upload the sample file ?

    This is mentioned in their PDF document

    // This method sets the method type to POST so that // will be send as a POST request httpConnection.setRequestMethod("POST"); // This method is set as true wince we intend to send // input to the server
    Does this give any information?
    Attached Images Attached Images
    Last edited by anilpatni1234; 10-10-2018 at 01:00 PM.

  24. #24
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    At which line do you get that error?

  25. #25
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    At this line I get error,

    Please Login or Register  to view this content.
    Do you want me to upload sample file for your convenience?

  26. #26
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    Ah, right. I forgot that function is only available from Excel 2013 or later.

    Add code found in link below, and replace Application.EncodeURL(myMsg) with... encodeURL(myMsg)
    http://cwestblog.com/2012/10/16/vba-...arts-in-excel/

  27. #27
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Ummm,

    Do you mean this ?

    I am really sorry for asking such basic questions...


    Please Login or Register  to view this content.

  28. #28
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    Yes. That looks correct.

    You can check that message is URL encoded by using Debug.Print above 'dest =' line and looking in immediate window.
    Please Login or Register  to view this content.

  29. #29
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Sure.
    Thanks.

    I have added a button and assigned the macro.

    After I click the button I get a error

    API08: Please pass the required parameters.


    What do i do now?

  30. #30
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    That means, that the code is working and sending request to the API, and got a response from the server.
    However, you are missing some parameter(s) required by API.

    If you are using Unicode messaging, add "&msgtype=uc" at end of sReq string.

    Also looking at their sample, you may want to end sReq string construction by adding & "" at end.

    However, since the response they returned isn't very specific, I'd suggest working with the vendor to fine tune it.

  31. #31
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    I have asked the vendor.
    They provided me this:


    The variables to be used are:
    mobile : my mobile number
    pass : Your Password
    senderid : SMSBUZ
    to : Recipient Number
    msg : Actual Message to be sent
    msgtype : uc(Compulsary only for unicode messaging)

  32. #32
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    The code has all that, except for msgtype. Add that in and see what's returned.

    Use Debug.Print to check that the string generated is meeting requirement and match request pattern.

    Don't think I can help you further as I don't have access to their API.

    You have base code for using their API and how to construct request string. All you need to do is ensure all the correct info are sent.

  33. #33
    Registered User
    Join Date
    10-11-2018
    Location
    Gurgaon
    MS-Off Ver
    XP
    Posts
    10

    Re: Vba to send sms to mobile number

    Thanks you very much for sharing this code. It helps a lot.

  34. #34
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hi,

    sorry for the delayed response .
    I was checking with the vendor .
    So i contacted the vendor , they sent me this:

    Please check last part :
    Please Login or Register  to view this content.
    Last edited by anilpatni1234; 10-12-2018 at 09:00 AM.

  35. #35
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    I got this code from their PDF file.
    I was wondering if we can use .net code in excel and assign it to a button?

    Please Login or Register  to view this content.

  36. #36
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    Ok so they don't accept sReq in Send parameter.
    You need to concatenate it to baseUrl.
    Try...
    Please Login or Register  to view this content.
    And no, you can't use .NET in VBA.

  37. #37
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    This part of the code should be this itself ?
    Please Login or Register  to view this content.
    OR

    Please Login or Register  to view this content.

  38. #38
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK.

    THis code worked perfectly.
    I was able to send SMS.

    THANK YOU SOO SO SO MUCH.

    This wasnt a easy task. THANK YOU SO MUCHHHHH

  39. #39
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    You are welcome and thanks for the rep

    If this has solved your query. Please mark the thread as solved by using thread tool found at top of your initial post.

  40. #40
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK ,

    Is it possible to link 2 cells in the text message?

    Example :
    My test message is "Hi you made a sales to CUSTOMER with AMOUNT . "
    Here I want to link CUSTOMER name to cell C3 and amount to cell Q42 .

    IS it possible?

  41. #41
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    Yes...

    Something like
    Please Login or Register  to view this content.

  42. #42
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Ummm,

    Thanks for your response, However

    I am getting an error
    "Compile error
    Duplication declaration in current scope"

    Getting error at
    Please Login or Register  to view this content.
    Here is my full code:
    Please Login or Register  to view this content.

  43. #43
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    Right, so I added as demo. Since you have myMsg declared in the code already. You shouldn't declare it again.
    Meaning, just remove "Dim myMsg as String" line.

  44. #44
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Sure,

    Thank you so much.
    It is detecting the cell C3 which is customer name
    However it isnt detecting Cell Q42 which is amount.

    Is it because it is not in text format?
    Its in numerical format

  45. #45
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    That has no relevance.

    Are both in same sheet? If not, remove "With..." and "End With" line and prefix each .Range() with Sheets("WorksheetName") that each cell belongs to.

  46. #46
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    It was some basic problem.

    Now I am able to detect the amount.

    Its working perfect now.

    Great.

    THANK YOU SO MUCH

    Thank you for helping me out for the past few days!

  47. #47
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK,

    I am facing a problem.
    If my wifi on my PC is working then the code works great.
    However if by any chance the wifi is off then I get a error.

    Here is the error:
    Run Time error '-2146697211(800c0005)'
    This system cannot locate the resource specified.
    Please Login or Register  to view this content.
    is it not possible to send the message when the internet connection is back?
    like how it gets stored in outbox in mails
    Last edited by anilpatni1234; 10-14-2018 at 09:50 AM.

  48. #48
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK,

    were you able to glance through?

  49. #49
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK,
    Trust you are well

    Were you able to glance through?

  50. #50
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    Well... if you are not connected to internet/wifi... there's no way to send SMS.

    So you either have to store dest in some other sheet and retry it later, or test that you are connected to internet before you send SMS.

    It's really up to you and what actual use case would be.

  51. #51
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK ,
    sure.
    The problem is that at times there are no internet connection.
    so is it not possible to remove the error message if there is no connection ?

    Because it fails to send the sms, it stops performing other functins as well.
    Currently I have made a command button which performs 4 macro functions in sequence.
    Since it fails to send the sms, other functions are not carried out.

    So is it not possible to simple ignore sending sms if in case there is no internet connection?

    Thank you

  52. #52
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    Add error trap.

    Ex:
    Please Login or Register  to view this content.
    You can read more about error handling at links below.
    https://excelmacromastery.com/vba-error-handling/
    http://www.cpearson.com/excel/errorhandling.htm

  53. #53
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK,

    Thank you for your reply:

    Did you mean this?
    Please Login or Register  to view this content.
    However it does not work.
    Please help me

  54. #54
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK,
    i am getting the same error even after adding the code which you asked me to add:

    Here is the code:

    Please Login or Register  to view this content.

    This part is creating problem
    Please Login or Register  to view this content.

  55. #55
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    On error... Line should be above the line causing error.

  56. #56
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK,

    Thanks for your promt reply.

    However I am facing the same issue:


    Please Login or Register  to view this content.
    Please help me

  57. #57
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Vba to send sms to mobile number

    ... please read the links I provided you with.

    ErrHandle: itself should be below .Send.

  58. #58
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Vba to send sms to mobile number

    Hey CK,


    THANK YOU SO MUCHHHHHH
    WORKS GREAT !

    THANK YOU

  59. #59
    Registered User
    Join Date
    04-17-2019
    Location
    nigeria
    MS-Off Ver
    windows 10
    Posts
    6

    Re: Vba to send sms to mobile number

    hello i have a similar issue. i have spreadsheet that i use to send email via outlook based on certain criteria in a cell. i want to be able to configure it to also use the API supplied by my bulk sms provider to send sms. The SMS provider has sent me the API now i need to make it to utilize these conditions.

  60. #60
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Vba to send sms to mobile number

    Quote Originally Posted by Goodi View Post
    hello i have a similar issue. i have spreadsheet that i use to send email via outlook based on certain criteria in a cell. i want to be able to configure it to also use the API supplied by my bulk sms provider to send sms. The SMS provider has sent me the API now i need to make it to utilize these conditions.
    Administrative Note:

    Welcome to the forum.

    As a new member, please take the time to review our rules. There aren't many, and they are all important.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

  61. #61
    Registered User
    Join Date
    04-20-2020
    Location
    Egypt
    MS-Off Ver
    2016
    Posts
    2

    Re: Vba to send sms to mobile number

    Hello CK,
    I am trying to customize this code to send monthly payroll payslip by SMS to each employee mobile number and I have my carrier API guide I can send it to you
    Do you have any suggestion how this could be done?

    Thanks in Advance

  62. #62
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Vba to send sms to mobile number

    Quote Originally Posted by m.safwat_6391 View Post
    Hello CK,
    I am trying to customize this code to send monthly payroll payslip by SMS to each employee mobile number and I have my carrier API guide I can send it to you
    Do you have any suggestion how this could be done?

    Thanks in Advance
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extract a mobile number from string AND remove the spaces?
    By Akshay in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-14-2018, 11:05 AM
  2. Mobile Number Formatting: E.164 standard
    By kingofcamden in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2016, 05:33 AM
  3. [SOLVED] How to make a pair of a mobile number
    By ravanreturn in forum Excel General
    Replies: 2
    Last Post: 03-08-2014, 01:21 PM
  4. [SOLVED] Random Formula for Mobile Number
    By SaleenaKhan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-11-2013, 09:09 AM
  5. Can not save mobile number of 12 digits in CSV
    By Yogi28 in forum Excel General
    Replies: 4
    Last Post: 08-22-2012, 01:33 PM
  6. Excel calculating mobile number value
    By john_prince in forum Excel General
    Replies: 3
    Last Post: 02-18-2010, 11:38 AM
  7. Replies: 1
    Last Post: 02-03-2005, 08:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1