• Tend to agree with Andy. Don't forget the SQL Mail is a subsystem added on to SQL Server. I'd be wary of switching profiles as you may cause instability on the server, which wouldn't be worth it. I'd go with Andy's suggestion and use CDO or CDONTS to send the mail.

    Steve Jones

    steve@dkranch.net