Re: [MSAccessProfessionals] Send Text Message

I think you can send text messages from Outlook, or any email provider, to most text providers, you just need to know the domain name they use. For example I have AT&T as my mobile carrier hence if I send an email to mynumber@mms.att.net it comes to my phone as a text message. If you don't know your text domain name, just do the opposite. Send a message to your email address as a text message from your phone and you will see the originating domain. 

Sorry doesn't answer the original question, but confirms VBA should be able to do it.

Sean

On Tuesday, March 16, 2021, 08:13:17 AM CDT, Arnelito Puzon <agpuzon@gmail.com> wrote:

Most Mobile service provider now has a way to use VBA to send messages.

all you need to do is inquire for the service and the api to use.

On Tue, Mar 16, 2021 at 12:55 AM myguyj@aol.com annr516@aol.com <gina@access-diva.com> wrote:

You would need a table to store the SMS Gateway information (you can Google it) which would require you to know the receiver's carrier.  At that point you can slightly modify the Send eMail (via Outlook) module.  You only need the…

 

.Subject (make it brief it's a text message)

.BodyFormat = 1 'olFormatPlain

.Body (where your message goes, again make it brief it's text message)

 

 

Gina Whipp
Microsoft MVP (Access 2010-2015)

Specializing in Microsoft^© Access^® Solutions

 

From: MSAccessProfessionals@groups.io [mailto:MSAccessProfessionals@groups.io] On Behalf Of Duane Hookom
Sent: Monday, March 15, 2021 11:05 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Send Text Message

 

I googled and found a video on how to do this with Twilio and VBA in Excel.

https://www.youtube.com/watch?v=rmcmQjgFu9I

 

Duane

 

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Youssef <youssef2309@gmail.com>
Sent: Sunday, March 14, 2021 4:26 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Send Text Message

 

1- Is it possible to send a text message from my Access database to particular cell phone number?

2- Is it possible to send a text message from my Access database to specific WhatsApp account?

if possible thanks to explain in deep details hot to do this

thanks in advance

--

Arnelito G. Puzon