Bryan, thanks for your very informative reply.


Just to confirm two things:

1) I dont understand how the email ends up on the Text of the Cell Phone.. will this not just be emailed and end up on his desktop in outlook ?

2) My preference would be to stay in VFP... is it necessary to use SQL7 , this would intoduce a whole new layer which I dont think would be viable.

regards,

Gerard



>Gerard,
>
>If it were me I'd use the mail functionality within SQL7 and call that functionality by using the SQLExec() command.
>
>This works very reliably and you can encapsulate a query result within the body of the email... so you could use VFP as the front-end to the SQL database of calls, then kick off an email routine at the end of the shift that sends all the calls via pop3 to the worker bees. You could even use the SQL 7 server as an SMTP server if you wanted to...
>
>handle=sqlconnect('DMC','videomgr','videomgrdmc')
>=sqlexec(handle,"Use VideoLib")
>=sqlexec(handle,"SET QUOTED_IDENTIFIER OFF")
>
>e_fullname = "Kathleen Pare'"
>e_location = "Tarver Elementary"
>e_name = "Kathleen"
>e_id = "2298"
>e_qry="Select Item,Title,rent_date as Pony_to_You,back_date as Pony_to_DMC,"
>e_qry=e_qry+"status as Status from orderstat where cust_num=&e_id"
>e_add="Kathleen Pare'@servername.edu;Bryan_Friberg@ad12.k12.co.us"
>e_sub="Your Video Library Request"
>e_msg=chr(13)+"(&e_fullname @ &e_location)"+chr(13)+chr(13)
>e_msg=e_msg+"Dear &e_name,"+chr(13)+chr(13)
>e_msg=e_msg+"This informational e-mail is generated automatically. Please do not "+chr(13)
>e_msg=e_msg+"respond. Your order has been processed as follows:"+chr(13)
>
>statement = 'exec master..xp_sendmail "'+e_add+'",@subject="&e_sub",'
>statement = statement + '@message="'+e_msg+'",'
>statement = statement + '@query="&e_qry"'
>retcode=sqlexec(handle,statement)
>
>
>ENJOY!
>
>-B