How to Send SMS Text Messages from Microsoft Access
Вставка
- Опубліковано 19 вер 2024
- In this episode, we're going to take a look at how to send SMS (aka text messages) from our Microsoft Access database using VBA and the Twilio service. We'll go through the steps of building our URL and data variables, creating a http request object, and then sending a SMS message to a phone to see the results. Let's go!
Related Videos:
How to Send Email from Access Using VBA - Table Queue Example
• How to Send Email from...
How to Send WhatsApp Messages from Microsoft Access
• How to Send WhatsApp M...
How to Send SMS Text Messages from Microsoft Access
You are watching this video now!
Get a Twilio account:
www.twilio.com
Join me on Patreon!
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
www.patreon.co...
Check out some tech (and support my channel!):
www.amazon.ca/...
Want the code from this video?
mackenziemacken...
Interested in transforming your career or finding your next gig?
system.billzon...
Want my team to do a project for you? Let's get to it!
system.billzon...
Contact form you can find at www.mackenziema...
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksyne...
Got a UA-cam Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#msaccess #twilio
- SMS is generally not free. So you need to buy into a provider and get a phone number
- I used Twilio www.twilio.com
- Make an account on Twilio, log in, go through three steps including getting a phone number
- Go to Messaging > Try it out > Send an SMS > Try sending to yourself > note accounts, passwords, and data fields
- Upgrade your account if necessary. Minimum is low, only $20
- Use the data fields etc. that you collected in order to use MS Access like you see here
- My Skype number can accept text messages. I also tested this on my phone with great results.
- Long Codes (10 digit numbers) can send a few hundred messages per day before being capped
- Short Codes (5 or 6 digit numbers) can do bulk SMS messaging with fewer restrictions
What kind of project are you guys using SMS messaging for?
will it works in Bangladesh? bro
Could definitely see the practical use case for this, thank you
You bet!
Amazing video. I will try to implement this in my project. I have a table of numbers, i want to send a single sms to all the numbers in my table that meet certain criterias "active". Hopefully I get no error
Cool project!
Thank you, Sean. It works great! I have many non-profit clients that can use this code.
Hey that's great! Glad to help. Sooo handy for alerts, and it does not get lost in the email zoo.
Great Idea in a video. Thank you.
Glad you enjoyed it!
Good video sir, Is it possible to send bulk messages that are customizable to each receiver like Mail Merge?
You could easily just make a table with a few hundred custom messages and loop through the table, sending an SMS on each pass. This apparently will work for "long code" ie 10 digit numbers. Apparently only "short code" numbers are pre-approved for mass texting (those short 5 or 6 numbers you receive messages from sometimes).
To loop through a recordset: ua-cam.com/video/7HckYjH_wg4/v-deo.html
Personally, I would pause on each send, maybe for a few seconds: ua-cam.com/video/rrcoA02JcwM/v-deo.html
Also, as the loop progresses, pass control back to Windows so your system doesn't show "Not responding": ua-cam.com/video/BPT-_H1ir6k/v-deo.html
Hi Sean, I ama getting the following error "Failed with error# 410 Gone" any idea? thanks Norbert
It indicates that the http target was there but is no longer. It could be a syntax error or something, or your Twilio account expired or something. Bit of a mystery!
This is amazing, just what I needed. Question, can Access receive messages? Also when I send text messages using special Spanish characters, it uses double segments, do you know how I can get around that?
I'm glad it worked! It looks like Twilio can receive messages for your Twilio phone number, and you can configure it to do a http POST to a service you can write, each time a message comes in. Great topic for another video. I didn't try with special characters, but if you use any special characters beyond GSM-7, your limit is 70 for each segment, not 160 as it is with GSM-7 (basic) characters.
@@seanmackenziedataengineering okay awesome, I appreciate it.
@@seanmackenziedataengineering are you considering making a video about this? Incoming Twilio text messages to access? Great content!
Hello, I need this solution for school but the messages should be triggered by biometric devices
Those devices must leave records somewhere. Find out where. Then, you can either create a trigger (active solution) or a polling procedure (passive) in MS Access that checks for records. Then, send messages at will!
@@seanmackenziedataengineering it's a complete attendance with MS Access dB, kindly share your email address so that you can create for me a simple solution for this at a cost
Please explain how to copy the link from the twilio website and do the programming. I tried that but I could not
On your default page in Twilio you'll see Account SID. Copy it and paste it into the link I describe at 4:40 in this video. That is the link you use. Between the slashes like Account/youraccountsid/
Do you know if MS Access can send faxes using VBA?
Good question.. probably the best method would be to use an email-to-fax service, though you could research DoCmd.SendObject too!
Thank you 😊
In case you guys want to see one of my projects where I use this technique, check it out: ua-cam.com/video/dxGjMa9hjaY/v-deo.html