Results 1 to 8 of 8
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    SMS From Access 2000 to 2003 (2000 to 2003)

    Is there currently any way to easily send sms text messages from access.
    I am looking at possible active x controls or an even cheaper method.
    I say the thread from 2004 BUT I am guesing things have moved on since then.
    I belive there is facility in Outlook 2007 and I know it can be done with SQL 2005, BUT this system only uses Access 2003
    Andrew

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

    Re: SMS From Access 2000 to 2003 (2000 to 2003)

    See How can I send a text message to a group using Access (ignore the warning at the top that you need to join to view the answers, just scroll all the way down). Apparently it's as simple as

    DoCmd.SendObject , , , "123456@o2.com", , , "Subject", "MessageText"

    You need to know the recipient's provider for the bit after the @ - see Providers for a partial list.

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: SMS From Access 2000 to 2003 (2000 to 2003)

    Gave that a try.

    No error messages but have received NO sms text message either.

    Also how do you prevent the outlook pop up message
    saying outlook is trying to send a message with the allow, deny cancel buttons.
    Andrew

  4. #4
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: SMS From Access 2000 to 2003 (2000 to 2003)

    OK, just got a rejection message from the server saying

    ------------------------------------------------------------------------------------
    - These recipients of your message have been processed by the mail server:
    xxxxxxx@vodafone.net; Failed; 5.1.1 (bad destination mailbox address)

    Remote MTA 10.196.79.80: SMTP diagnostic: 550 RCPT TO:<xxxxxxx@vodafone.net> User unknown

    ------------------------------------------------------------------------------------

    I replaced the actual number I used with xxxxxxx on this thread.
    Andrew

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

    Re: SMS From Access 2000 to 2003 (2000 to 2003)

    The Outlook warning can be suppressed by installing ClickYes (the basic version is free, the Pro version is not).

    Did you use the complete phone number? Have you tried adding the international access code 44 or +44 to the phone number?

  6. #6
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: SMS From Access 2000 to 2003 (2000 to 2003)

    I had a copy of ClickYes (forgotten about it though) so thanks for reminder.

    I have tried using the international +44 code in various variations

    +44 and also 44 and also 0044 in front of the number
    BUT all get the same error message.

    Maybe it is a Vodafone issue.
    Andrew

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

    Re: SMS From Access 2000 to 2003 (2000 to 2003)

    Perhaps you'll need one of the ActiveX controls after all...

  8. #8
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: SMS From Access 2000 to 2003 (2000 to 2003)

    I have been looking into this lately.

    The option provided by Hans has worked for me in testing - vis send an email to number@provider.
    Provider is not necessarily your own mobile phone provider. It is some who provides a gateway service that you will need to set up.

    Another option that seems better if you can use it is Skype. I attach a sample mdb that sends SMS directly from within Access 2003 using Skype.
    I am unsure about cost. In my testing the messages seem to be free. I gave it to someone else who says he is charged about 11c Aus per message.
    Attached Files Attached Files
    Regards
    John



Posting Permissions

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