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