Thanks all for help checked logs nothing reported not even getting to mail queue so started from scratch, this time decided not to set as an attachment and this has...

Yes the syntax I posted is missing a quote. Sorry this is correct in my code, took it out by accident when posting code to forum.

Thank you for the reply have tried but no luck even though I know the sql has generated rows nothing sent