I updated the URL , and now the id 's are braodcasting .
Thanks everyone for the input's
DECLARE @body varchar(max) =
'<a href=''http://someurl.com/?id=' + CAST(@ID As varchar(20))+'''>Please click here to fill your missing details</a>';
EXEC [dbo].[sp_send_mail]
'a@a.com',
@Email,
' Submission',
@body,
'htmlbody',