API Connection with MS Access Database : VBA

[Raza12]

we have developed an application on Ms access database and working on this application since 2017 and have a lot of data stored in this database, we want to integrate via API ms access data base to send sms service to our client , is it possible , if yes then please send VBA Code

[NeoPa]

Raza12:
is it possible, if yes then please send VBA Code

It is possible. How you do it depends on which SMS service you want to use. As for sending the code, that's not really how we work. You'd need to ask a specific question and then build the code yourself once you understand how to.

[isladogs]

I added both SMS & voicemail messaging to one of my commercial apps for schools several years ago. It works well.
To do so, you will need a suitable provider who will have an API for you to use - I used Twilio as their prices were reasonable and their documentation is excellent. Files can be in various formats: CSV, XML or JSON. Each has advantages and disadvantages

I have written many posts about this at various forums including this lengthy thread whilst I was developing the code: Using-twilio-with-access-to-send-receive-text-voice-messages

I strongly recommend you read this article which was enough to get me started: Twilio-from-excel-and-access

Although I'm very happy with my chosen provider, there are several other providers to choose from so do some research yourself.

Good luck