How can I send a text message to a group using Access
Posted on 2008-02-07
I need to design a mechanism that will generate sending a text message to a queried list (group) of mobile phone numbers. One way I thought of doing this was using the sendobject function in Access and send an email, the address of the email would in fact be the phone number and carrier, for example, firstname.lastname@example.org. This would send an email to a mobile phone that accepts text or email messages. The process that I am trying to accomplish is to send a notification text or email to a cell phone. I'd like to set up a form in Access and have this function connected to a command button. To give a brief scenario of why I would want this function: if a staff meeting was being cancelled or delayed, I would want the ability to send an email (text message) to the staff members' cell phones. In today's world, it's much easier to reach a person by cell phone and not email. Any help or suggestions would be greatly appreciated. I am not an expert Access user, but am willing to put the time in to learn and understand. Thank you in advance for your time.