Hi Sue,

I have only found 2 reasons why the email script would not work, maybe you can check these on your system.

1- SMTP service is not running on the box that is running SQL Server. Turn SMTP on.

2- Port 25 is blocked and preventing email to be sent outside the business LAN. If this is happening, simply send the email to yourself within the LAN using the procedure. This usually will be picked up within the LAN without a problem. Then have a rule forward the email to your 'second' email that you use for your phone, or pager.

I have seen the latter happen often.

Oh... BTW. 'Persons.dbf' was a comment I forgot to exclude. Sorry about that, you can simply ignore that one. My mistake.

Hope this provides an easy fix.

Anthony Loera