I think you might be overthinking this.
After your existing SELECT statement, just do something like this:
SELECT @Email = COALESCE(@Email, 'firstname.lastname@example.org')
You need to make it a separate step.
Also, think about how many emails there may be max because right now you have @Email at only 200.