Share via

Send SMS message from access

Anonymous
2021-07-16T23:06:49+00:00

I have a database with our clients name and mobile phone number

I would like to send a SMS message to the customer direct from the form I am using

It is a simple message - not marketing just "Hi John, deadline for tomorrows deliveries is approaching - do you want any Stock"

I have found lots of suggestions and the vba programming can run up to 4 pages - way more complicated than I need

I just want a SEND button and the message goes

I have another button for EMAIL as some want there reminders by email and that works fine

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-07-17T17:53:30+00:00

    You can normally use "Email to SMS Gateways" which means you send an email to the person cell phone number and the company relays it as a text message.

    The following link has many of the email addresses to be used

    https://www.quertime.com/article/arn-2010-11-04-1-complete-list-of-email-to-sms-gateways/

    4 people found this answer helpful.
    0 comments
  2. DBG 11,711 Reputation points Volunteer Moderator
    2021-07-17T17:33:43+00:00

    Some cell service providers include an email address to send a text message. Either that or you can subscribe to a SMS service provider to send your messages online through VBA.

    1 person found this answer helpful.
    0 comments
  3. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2021-07-17T16:32:41+00:00

    Search online for "sms from vba" and you will find plenty of leads. The ones for Excel apply to Access as well.

    0 comments