[AccessD] SMS Phone text messaging from Access

MartyConnelly martyconnelly at shaw.ca
Sun Jan 15 13:15:30 CST 2006


Here is an Access one liner to send a Phone SMS text message to any cell 
phone in North America.

DoCmd.SendObject , , acFormatTXT, "250-555-1212 at teleflip.com", _
, ,  "SMS Message from Access"," Body this is a test from Access" , False

Using teleflip.com SMS portal avoids having to distinguish between these 
cell phone SMS portals below
Here are some cellphone providers that you do have to know the carrier of
the cellphone you want to send email to:
AT&T:   AreaCode+Mob... at mobile.att.net
Verizon:   AreaCode+Mob... at vtext.com
Nextel:   AreaCode+Mob... at page.nextel.com
T-Mobile:   AreaCode+Mob... at tmomail.com
Sprint:   AreaCode+Mob... at messaging.sprintpcs.com
Cingular:   1+AreaCode+Mob... at mobile.mycingular.com

Given Teleflip's privacy policy of storing text messages and numbers  
for business purposes
(that veils a multitude of sins). I would only use to message such 
things as an
indicator of  computer job run termination or sql server failure.
And given the recent press announcements that you can obtain a list
of called numbers for a particular cell phone from a broker, does anyone 
see
any other security problems with this messaging method?

http://www.teleflip.com/teleflip/index.jsp

http://abtolls.com/information/sendatextpage.html

Advanced SMS methods to handle acknowledgement etc.
http://www.microsoft.com/sql/ns/partners/delivery.asp

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list