SMS Text Messaging from within MSACCESS Database

[tasawer]

Hi,

I wish to use MSAccess to be able to send sms text messages, either using a bluetooth device or other available method.

I am not sure where to start so I am looking for professional guidance.

Regards

[beacon]

Hi tasawer,

I can't address how you would be able to send a text message using a bluetooth device because it was my understanding that bluetooth has a limited range, and unless the people you are sending the messages to are within a very close proximity, bluetooth wouldn't serve you very well.

You will basically need to automate Outlook from within Access to send the messages. Essentially, you would be sending the text message exactly the same way that you would send an email in Outlook, except that you would be using Access to tell Outlook to send the message.

There are literally hundreds of articles on the web that address automating Outlook from within Access (including several posts in this forum)...you'll just need to tweak the code to meet your needs.

I can't speak to this with any certainty, but if you are using Office 2007/2010, I believe there is a specific feature for sending text messages in Outlook, which you can reference in the code.

Hopefully this helps to get you started.

[tasawer]

HI Beacon,

Thank you for starting me off.

Apologies, my note was very brief indeed.
by Bluetooth, I meant, having my mobile phone linked up by bluetooth.
and by other available device, I meant hardware like GPS Modem etc.

Nevertheless, your advice has given me some pointers and I will start me research.

Regards

[tasawer]

I am using MS ACCESS 2003 and I have downloaded MOSA for MS Outlook.

http://www.microsoft.com/downloads/details.aspx?FamilyID=240080b4-986e-4afb-ab21-3af2be63508b&displaylang=en

I have added code below to a command button.

When send text message manually through MS Outlook, it works ok. but from within ACCESS, it only ever worked once. Thereafter, I get the message "THE OPERATION FAILED"
(mobiletxt is the field for mobile number in text format)
Please provide appropriate help and advice

DoCmd.SendObject , "", "", Me.Mobiletxt, "", "", "Nothing", "Hello", True, ""