Solved

Send text message from Access

Posted on 2014-02-12
3
1,817 Views
Last Modified: 2014-02-27
I'm looking for advice on the best was to send text messages to customers via vba from access 2010.
0
Comment
Question by:cmccurdy
  • 2
3 Comments
 
LVL 57
ID: 39854150
The simplest is to treat it as an e-mail.  Most phone services will accept <number>@verizon.net.

Sending mail from Access can be done with BLAT, vbSendMail, CDO, or Outlook, or a 3rd party mail control.

The other method would be to POST a message to a web service.

Jim.
0
 

Author Comment

by:cmccurdy
ID: 39854460
Jim,  

The text message is to inform customers of the status of their work so the I only have the phone numbers, not the phone service vendor.  So the email solution is not viable.  Can you give me any information on  a web service to POST a message to?
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39854529
<<So the email solution is not viable.>>

 Well you could send the text to each carrier.

<< Can you give me any information on  a web service to POST a message to? >>

 There are services out there such as twilio:  www.twilio.com

 which will provide a web API for your app to call and then send/receive SMS messages.

Jim.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question