I think you can adapt this to work for you:

EXEC msdb.dbo.sp_send_dbmail

@profile_name='<the name of the profile you created in Database Mail>',

@recipients='<10 digit cell phone number>@txt.att.net;emailName@emailServiceProvider.com',

@subject='<any printable characters>',

@body='<any printable characters>'