How to Send an SMS Text Message from Microsoft Access
Question details
The user wants to send an SMS text message triggered by an Access form button.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Automating or triggering basic SMS text notifications directly from a database application form.
- Observed behavior
- Needs to configure Access to route basic, non-marketing text messages either via an email-to-SMS gateway or a dedicated SMS service API using VBA.
Before configuring your database to send texts, ensure you know the recipient's mobile carrier (if using email-to-SMS) or have an active account and API credentials with a VBA-compatible SMS service provider.
Use an Email-to-SMS Gateway
Best for occasional messages, this method sends an email from Access to a carrier-specific domain, which the carrier then converts into an SMS text message.
Most mobile carriers provide an email-to-SMS gateway address. By sending a standard email to this address, the carrier forwards the email's body as an SMS to the recipient's phone. This requires knowing the recipient's carrier.
Determine the recipient's mobile carrier and locate their email-to-SMS domain (e.g., phonenumber@txt.att.net for AT&T or phonenumber@vtext.com for Verizon).
In Microsoft Access, open your form in Design View and add a Command Button to the form.
Right-click the newly added button, select 'Build Event', and choose 'Code Builder' to open the VBA editor.
Use the DoCmd.SendObject method or write an Outlook automation script in VBA to send an email. Set the 'To' field to the 10-digit phone number combined with the carrier gateway address, and put your text message in the email body.
Integrate an SMS Provider API using VBA
Ideal for reliable automation and larger volumes, this method uses a dedicated SMS service provider that accepts VBA REST API requests.
Looking for a Lightweight Office Suite?
While Microsoft Access is tailored for complex database tasks and VBA integrations, you can handle your everyday document, spreadsheet, and presentation needs with WPS Office—a lightweight, free, and highly compatible alternative to Microsoft Office.
Frequently Asked Questions
Do I need internet access to send an SMS from Access?
Yes, whether you are routing messages through an email-to-SMS gateway or making HTTP requests to an SMS provider's API, an active internet connection is required to transmit the data from your database.
Can I use Excel VBA code for SMS in Access?
Yes, VBA code written for making API calls or sending emails in Excel is generally compatible with Access. You will simply need to adjust the variables so that the phone numbers and messages are pulled from your Access tables or form fields rather than Excel cells.
Why are my email-to-SMS messages being delayed or dropped?
Mobile carriers often deprioritize or actively filter incoming email-to-SMS traffic to prevent spam. If you need guaranteed delivery or are sending multiple messages simultaneously, switching to a dedicated SMS API service is highly recommended.
