Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    VBA Code to send SMS messages (XL97 and >)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Loungers

    Anyone has found, or written, a snipit of code that would allow us to send SMS, short message services, or text messages to mobile devices such as cell phones, iPhones, RIM blackberries and the likes.

    We need to send an alert message to about 70 to 80 devices that a worksheet has been updated. I guess the mechanizim of sending the message would be via the last person to update the worksheet to press a button on the worksheet and thus trigger the code and send the notifications.

    Any ideas. We do have MS-Outlook loaded and most of these 70 to 80 people have e-mail accounts, but not all.

    Thanks for any ideas

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA Code to send SMS messages (XL97 and >)

    See <post:=726,254>post 726,254</post:> by macropod.

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: VBA Code to send SMS messages (XL97 and >)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Hans

    I was hoping to avoid any 3rd party software, so that we do not have to go through a certification process by the MIS/IT department which typically takes a while to finish.

    Is Skype the only way, to do this?

    Thanks again

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA Code to send SMS messages (XL97 and >)

    If you know the recipient's cell phone provider, you can send an e-mail (which can be automated from Excel) to phonenumber@providercode. For example, if your cell phone number is 123-456-7890 and Verzion is your provider, I can send an e-mail to 1234567890@vtext.com; it will be converted automatically to an SMS to your cell phone.
    Unfortunately, you do need to know the provider. See Send SMS or Text Messages to Cellular phones for a list of US provider codes.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Code to send SMS messages (XL97 and >)

    In Australia, I don't need to know the provider- I go through a third party provider- http://smsbroadcast.com.au (though in Googling today I've found a much cheaper provider).

    I send an email to phonenumber@provider.com.au and it sends an SMS, and charges me per message.

    I'd be very surprised if there aren't similar providers in the US.

    I use it for rosters. I build a roster in Excel, and the VBA code sends a message to each employee telling them their shifts.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

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