By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,442 Members | 1,316 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,442 IT Pros & Developers. It's quick & easy.

SMS Text Messaging from within MSACCESS Database

100+
P: 106
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
Jul 31 '10 #1

✓ answered by 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.

Share this Question
Share on Google+
3 Replies


beacon
100+
P: 579
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.
Jul 31 '10 #2

100+
P: 106
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
Aug 1 '10 #3

100+
P: 106
I am using MS ACCESS 2003 and I have downloaded MOSA for MS Outlook.
http://www.microsoft.com/downloads/d...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

Expand|Select|Wrap|Line Numbers
  1. DoCmd.SendObject , "", "", Me.Mobiletxt, "", "", "Nothing", "Hello", True, ""
Aug 8 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.