the problem is unless you have your own SMS service, you can't do SMs messages to cell phones;
while every carrier has a supprt email that allows an email to be sent to a cell phone number, you have to KNOW which carrier a phone number belongs to.
it used to be easy...the cell phones were registered to each carrier...but with the advent of keep your phone number when you switch, it's a lot harder.
once you have a persons 10 digit phone number, you can a 150 character email, including the SUBJECT line and send it to their carrier;
i typically leave the subject blank and use 150 char BODY for my messages.
once you have sp_send_mail set up and working, this might get you started:
use http://www.data24-7.com to find out which carrier a number is:
AT&T – firstname.lastname@example.org
Verizon – email@example.com or firstname.lastname@example.org
T-Mobile – email@example.com
Sprint PCS - firstname.lastname@example.org
Virgin Mobile – email@example.com
US Cellular – firstname.lastname@example.org
Nextel - email@example.com
Boost - firstname.lastname@example.org
Alltel – email@example.com
Cincinnati Bell Wireless it’s firstname.lastname@example.org
Metro Pcs email@example.com
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!