Send SMS from MS Access to Mobile Phone

[mshakeelattari]

Is there any way to send SMS from MS access to Mobile phone numbers? I have Samsung Galaxy J5. Does it have ability to do so? I use MS Access 2016 on My laptop with Windows 10. Please give any shortcut possible way. Thanking in anticipation.

[NeoPa]

Not natively, no.

You'd need to sign up for a service and then use that service as per instructions.

[mshakeelattari]

So please guide me to the service please.

[Rabbit]

If you send an email to the right domain, it will text the number. For example, 5555551234@tmom ail.net will text that number if it's a T-Mobile number. You can look up the domain for whichever ones you need on Google.

If you would rather use a service, you should Google for one in the country you need.

[mshakeelattari]

Does the mobile phone model I possess not have this ability or the MS Access?

[Rabbit]

You don't have the right hardware. You would need to set up an SMS gateway device to send texts from a computer. Which is why most people opt to use a service instead.

What phone you have has no bearing on your computer's ability to send texts. Unless you're somehow running Microsoft Access from the phone or leaving your phone connected to your computer.

[mshakeelattari]

Thank you for response. I use MS Access from my Laptop and, if it is possible to send sms from the Access database via phone, I can leave the phone connected to it. Please tell me the way. Thank you.

[Rabbit]

It would be cleaner and more stable if you went with a web service.

But if you really want to MacGyver it, one way to do so would be to install pushbullet on your computer. And install pushbullet and tasker on your phone. Then have Access use pushbullet to send a notification to your phone. Then have tasker parse the pushbullet notification and send the text.

[mshakeelattari]

I am not understanding any method. Please guide me completely for any method that may be adopted to send SMS from Access. I shall be very thankful.

[Rabbit]

Sorry, but that's not what we do here. You need to put in some effort. We're not here to do your work for you. Three methods have been laid out: a web service, using email to the cell provider, or installing and configuring apps on your computer and phone. You need to pick the one that you want to implement and then try to implement it.

[smsgateway]

If you're only sending occasional messages, connecting an Android phone like the Samsung Galaxy J5 to MS Access is possible using third-party SMS software or by communicating with the phone through ADB or a GSM modem. However, this approach can be difficult to maintain and isn't ideal for automation.

If your goal is to send SMS directly from an MS Access application, an SMS Gateway is a much more reliable solution. Most SMS Gateway providers offer REST APIs that can be called from VBA in MS Access, allowing you to send OTPs, alerts, reminders, notifications, or bulk messages without relying on a mobile phone. It's also more scalable and provides delivery reports and better reliability for business use.

If you're building a long-term application, I'd recommend integrating an SMS Gateway instead of using a phone as the messaging device.