How to Send WhatsApp Messages from Microsoft Access

WhatsApp messaging has become the cornerstone of communication for many businesses around the world due to its simplicity and low cost. In this episode, we're going to send WhatsApp messages through the well-known Twilio messaging service. We'll create our MS Access database, make a table with message rows in it, then make a button to send the message for whichever row our form has selected. We'll also take some time to show how to attach files like pictures or PDF files to our messages. 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
You are watching this video now!
How to Send SMS Text Messages from Microsoft Access
• How to Send SMS Text M...
Join me on Patreon!
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
www.patreon.co...
Thinking about studying data engineering? Get some help with the Sean MacKenzie Data Engineering Scholarship:
www.napier.ac....
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 KZbin Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#msaccess #twilio #whatsapp

[@seanmackenziedataengineering]

If you're interested, check out my Data Engineering scholarship: www.napier.ac.uk/study-with-us/bursaries/sean-mackenzie-data-engineering-scholarship

[@massambadiagnediop1942]

i am interested

[@abedalil8739]

Cool .. thanks so much sir .. But , if I can make attachment for some pic or document or word file .. etc ?

[@seanmackenziedataengineering]

At 18:00 you can see that I sent a PDF. You can use a similar technique for other files like jpg etc. You may need to host on something like DropBox and then get a link for a particular file to use like I did.

[@peteremmanuelololade9184]

Great Job sir, how can we do this for multiple phone numbers

[@seanmackenziedataengineering]

You can make a table with different recipients then do a loop and send to each. When you scroll to the next record, a different recipient will show. When you click your Send button, get the new number and put it in your procedure. If you mean multiple outbound numbers, you can do the same.. maybe a drop-down for Send From or something!

Hello, sir! Do you know the pricing for Twillio account, only for sending max 30 messages per day?

[@seanmackenziedataengineering]

It is pretty cheap - what I saw was something like USD0.005 per WhatsApp message. Pretty easy, just put some cash in the account and start.

I just do it totally free, I send messages directly from whatsapp, no limit, no costs.

[@marcinkaczmarek8852]

Hello, You have some idea to change direction of massage (data)? It is possible to send text by WhatsApp to Access?

[@seanmackenziedataengineering]

It is a good idea for a video - to receive into Access, you first need to receive the message from Twilio as a http POST operation, which isn't that hard if you have an exposed web server available. Someone sends to your number at Twilio, then Twilio sends the detail to your server as POST, then your MS Access database receives the message in a table from your server process.

[@Khabat.Hawrami]

Thank you and love it !

[@seanmackenziedataengineering]

So glad!

[@shakey3258]

Great vid❤. Will you be doing a How to receive a WhatsApp message ?

[@seanmackenziedataengineering]

Great idea for a video! In most cases, messages will be received by the mailbox of the host number. I’ll take a look!

[@peterhamer504]

Brilliant!

[@seanmackenziedataengineering]

Thx!

[@modestoegonzalez]

Thanks!

[@seanmackenziedataengineering]

Much appreciated!

[@ijo680]

Thank you for the video...very useful.. is there a way to get a file from your local drive?

[@seanmackenziedataengineering]

I don't think so. So, you'll have to use a service like DropBox or something in order to make a file available. You could script that from your DB though.

[@massambadiagnediop1942]

Where have you taken your api url ?

[@seanmackenziedataengineering]

Log in > Choose Twilio account if prompted > you'll see Account SID text > click copy Your URL is api.twilio.com/2010-04-01/Accounts/PasteYourAccountSIDHere/Messages.json

[@massambadiagnediop1942]

@@seanmackenziedataengineering thanks a lot so can i have the code ?

[@seanmackenziedataengineering]

@@massambadiagnediop1942 I posted on your other comment

[@massambadiagnediop1942]

@@seanmackenziedataengineering thanks i have seen it . can i use my own acompt instead of twilo

[@hishamyouness4324]

From where I can copy my twilio account URL? Can someone give me a detailed answer please?

[@seanmackenziedataengineering]

Log in > Choose Twilio account if prompted > you'll see Account SID text > click copy Your URL is api.twilio.com/2010-04-01/Accounts/PasteYourAccountSIDHere/Messages.json

[@gerfer6261]

🏅 What’s up next How about front end user login form with password encryption method please

[@seanmackenziedataengineering]

That's a great idea - I'll put it on my list :-)

[@akokohjoel9854]

Pls how can one Link Ms access to MySQL online database

[@seanmackenziedataengineering]

Just download the ODBC drivers for MySQL, install them, then link to ODBC under External Data in MS Access. You will need all of your MySQL addresses, ports, and user credentials. Cool project!

[@akokohjoel9854]

@@seanmackenziedataengineering pls I have been your follower , do you a link or video? Pls

[@abedalil8739]

If the website " twilio is free registration or what ?

[@seanmackenziedataengineering]

It is free to try out. You can send a few messages for free from there!

[@ashrafejaq7694]

what if i want to sent to WhatsApp group ??

[@seanmackenziedataengineering]

Possibly - I saw something about "Conversations" in the Twilio docs.

[@bskerem4342]

Hey i need help by sending Local files from my Pc, is there any Method ?

[@seanmackenziedataengineering]

You can send files to your local network using VBA. Use the FileCopy command. FileCopy "C:\some folder\myfile.txt" "\ emoteserver\folder\myfile.txt"

[@bskerem4342]

Thank you very much ! @@seanmackenziedataengineering

[@massambadiagnediop1942]

Très intéressant j'aimerais bien avoir le code

[@seanmackenziedataengineering]

Voilà mon ami: 'Sends a WhatsApp message Dim strUrl As String Dim strData As String Dim strUser As String Dim strPwd As String Dim objRequest As ServerXMLHTTP60 strUrl = "api.twilio.com/2010-04-01/Accounts/MY_ACCOUNT/Messages.json" strData = "From=whatsapp:[phone]" strData = strData & "&To=whatsapp:" & Me!WhatsAppTo strData = strData & "&Body=" & Me!WhatsAppMsg strData = strData & "&MediaUrl=mackenziemackenzie.com/MyPDF.pdf" strUser = "MY_ACCOUNT" strPwd = "MY_PASSWORD" 'Set up whatsapp request Set objRequest = New ServerXMLHTTP60 objRequest.Open "POST", strUrl, False, strUser, strPwd objRequest.setRequestHeader "Content-Type", "application/x-www-form-urlencoded" objRequest.send strData Debug.Print objRequest.responseText

[@sureshatsasi]

Sir access open invioce report send whatsapp on click vba possible sir post me video sir thank you sir

[@seanmackenziedataengineering]

This is a good idea for a video. Procedure would be something like, open the report in Access > Auto save PDF > Copy PDF to www-enabled directory (local IIS, dropbox, or file service) > send WhatsApp message with attachment link to the file you just put in web directory.

[@ChaseCCTV]

hiya sean ive watched many of your videos and have learnt alot , also ive never had any issue following your code, untill now :( im getting error 21604 a To phone number is required howver ive followed your steps and have a mobile number in the to field on the form i also added the +44 as im in the ~UK :(

[@seanmackenziedataengineering]

Thanks for asking.. how about without the + sign? I've had other feedback that numbers other than +1 could have issues. It will be worth investigating.

[@ChaseCCTV]

@@seanmackenziedataengineering hi i managed to get your sms video working great but this whats app video i just cannot get working, i did not find a download link to your source doe however, would it be possible you might be able to link it for me ,.

[@Nikola-d7f5h]

Great Job... but i have the same error ("code": 21211, "message": "The 'To' number whatsapp: 92XXXXXXXXXX is not a valid phone number.") The Script ignores the "+" in the country code, and assigns a space character. Please guide if already have solved this issue..... Thanks

[@seanmackenziedataengineering]

In your Twilio login, check how your phone numbers appear in the sample/example black screens, then try sending a message from there first. It helped me to get the format right. Develop tab on left > Messaging > Try it out > Send a WhatsApp message.

[@mineromatiz0121]

hey. thanks for the video. But i have the same error ("code": 21211, "message": "The 'To' number whatsapp: 57XXXXXXX is not a valid phone number.") The Script ignores the "+" in the country code, and assigns a space character. Do you can help me in this issue? thanks.

[@mineromatiz0121]

ok. im solved last night. thanks

[@seanmackenziedataengineering]

Glad you got it sorted!