Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
Home > TechHelp > Directory > Access > Text Messages < Late Binding | Conditional Formatting >
 
Text Messages
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   2 months ago

Send SMS Text Messages to a Mobile Cell Phone


 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Join Now

In this video, I will show you how to use Microsoft Outlook and an Email-to-SMS gateway address to send text messages from Microsoft Access.

Cameron from Olympia, Washington (a Gold Member) asks: I run a service business. I'd like the ability to be able to send SMS text messages to my customers to remind them of an upcoming appointment, or to let them know their technician is on the way. So many people don't check email regularly, but everyone carries their cell phones nowdays. Can this be done from my Access database?

Members

Members will learn how to send SMS text messages without using an email gateway. We will set up a free trial account on Twilio and use their API to send messages. This way, we avoid having to know the customer's cell carrier too.

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to contact me so I can set up your account here on my web site. If you're not a member, Join Today!

Links

Learn More

FREE Access Beginner Level 1
Access Level 2 for $1.00

Free Templates

TechHelp Free Templates
Blank Template
Contact Management
Order Entry & Invoicing
More Access Templates

Resources

Mailing List - Get Emails When New Videos Released!
Consulting - Need Help with Your Database?

Questions?

Please feel free to post your questions or comments below or submit them via the TechHelp page.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, send sms from vba, sending sms from access database, Can MS Access send SMS, How To Send SMS Messages With VBA, email to sms gateway, How to Send SMS Using MS Access, How To Send Bulk SMS With Twilio, SMS API, Learn How To Use Twilio to Send Unlimited SMS & Text, send text messages with vba, Vba to send sms to mobile number, Sending SMS from excel VBA, vb to send sms, Outlook vba send sms, Send SMS using Microsoft Access, sms api

 

Sending Messages Upload Images   Link  
Bert Harmsma 
26 days ago
Hi all. Good afternoon.

Do you also cover, somewhere in your courses, sending messages but now by WhatssApp?

Thanks in advance for your reply.

Greetings,
Bert
Adam Schwanz
26 days ago
Does Twilio offer whatsapp? If not you will have to google and find a WhatsApp API to use/buy for access.
Alex Hedley
26 days ago
https://www.twilio.com/whatsapp

https://www.whatsapp.com/business/api
Add a Reply
SMS Form Upload Images   Link  
Julian Okolonji 
31 days ago
Hi All

Hope you are all doing good?

I think I share the same problem with Larry. I've been trying to create a form to send SMS messages. I've tried using the same technic that was used in the email seminar but have failed. I've setup a paid account at Twillo and have been able to send test text messages but ultimately need a form as I share my db with other people who don't have access to the code. I really don't need to send bulk messages but still need a form for single messages.
Julian Okolonji
31 days ago

Scott Axton
30 days ago
Julian -
Was there a question here?
It appears by the message in your status box you didn't enter a valid phone number.
Add a Reply
SMS Text messages Upload Images   Link  
Larry Fisackerly 
2 months ago
(1) Do I have to set up my own server? (2) Do I have to have my own website to use this? (3) Do I have to type the body of my text message in the VBA code? (4) If so, does that mean I have to edit the VBA code each time I send a different message? (5) How to I select customers in Access to send text messages to? I know how to do queries, but did not see anything in the video about selecting customer to text.
Scott Axton
2 months ago
1) No.  2) No. You do have to have a working email address to send from (Email-to-SMS Gateway) or a Twilio account like in the extended cut.    3) Depends.  If you want to send a varying message each time you would have so have  a field in you form for you message.  If it is just a standard message then you could / would write it into the VBA.  4)  See reply for 3.  5) The message is sent from the customer form that is open in the example.  There would be other ways to send to multiple people but that would require some programming and VBA.

Be sure to watch the videos in the links - multiple times if needed.  Especially the Send Email. This isn't a quick plug and play type of thing.  You have to have some pretty solid foundation to understand how to tackle it.
In addition take a look at the Value From a Form video.  That would help you sending a message from your form text box. (Question 3 & 4)
  
Scott Axton
2 months ago

Some telephone plans still charge for messaging.  Be careful, and offer some way to opt out of text messages.  You don't want to alienate a good customer if this is for a business.

FYI - From Google:
Is there a limit on text size?
        "The character limit for a single SMS message is technically 160 characters. However, most modern phones and networks support message concatenation: they split large messages into individual SMS messages (called "segments") and then re-create the large message at the receiving end."

Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

12/4/2021Hangman!
12/3/2021Access Beginner 2
12/3/2021Access Beginner 2 Lessons
12/3/2021Access Beginner 2
11/30/2021Import Multiline Cells
11/30/2021Adam's Access Games
11/29/2021Prevent Close
11/28/2021Random
11/22/2021Currency Symbols
11/13/2021Access Developer 36
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: TechHelp Access send sms from vba, sending sms from access database, Can MS Access send SMS, How To Send SMS Messages With VBA, email to sms gateway, How to Send SMS Using MS Access, How To Send Bulk SMS With Twilio, SMS API, Learn How To Use Twilio to Se  PermaLink