SELECT @formattedbody = '<h1>Look at the results below</h1><table><tr><th>col1</th><th>col2</th><th>col3</th></tr>' +
(SELECT '<tr>' + '<td>' + col1 + '</td><td>' + col2 + '</td><td>' + col3 + '</td></tr>' FROM mytable WHERE myid = 5 FOR XML PATH(''),TYPE).value('.','VARCHAR(4000)')
+ '</table>'
EXEC msdb.dbo.sp_send_dbmail
@recipients=N'me@me.com;him@him.com',
@body=@formattedbody,
@subject ='Message Subject',
@profile_name ='DatabaseMailProfile'
Alternatively you could have a table that records the max ID from the view.
Then have a job that compared the latest max ID from your email log to the max ID in the view and, if greater sends an email out about any IDs beween the 2 and then adds a new record with the new max ID and status of email sending.