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)
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.
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
Tidak ada komentar:
Posting Komentar