On 31-10-2011 17:46, grip_2ls wrote:

> Hi Mark
>
> Thanks for the advise but I don't think that is the issue. If you remove the second select statement it compiles and runs fine.

That was exactly the issue I was pointing out. You are using SELECT
without INTO to call SendMail. That doesn't work as Sean also pointed out.

Mark
--
Mark Rotteveel