Re: [MSAccessProfessionals] Send Text Message

adding on to "if possible thanks to explain in deep details hot to do this"

in order to text a phone instead of send an email, you still have an address in this format:

whoTo@someWhere.com

where:
whoTo is generally the phone number, 123456789

someWhere.com is the domain for that service's phone numbers such as vtext.com for Verizon or bellmobility.ca for Bell Canada

~~~

so next is simply sending an email from Access. This can be one line for output, or a little procedure to open Outlook and fill out the email, to controlling much more

~~~

nice to see you, Gina ~

kind regards,
crystal

~ Access tutoring. Let's connect and build what you need together. ~

On 3/15/2021 11:53 AM, myguyj@aol.com annr516@aol.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