Hi,

You could try

SELECT @mailto = (SELECT Email from mawdata.dbo.vwCurrebentEDemails where id = '5')

instead of

SELECT @mailto = Email from mawdata.dbo.vwCurrentEDemails where id = 5'

Kindest regards

Richard