Need to fetch latest record always and ignore if there is no latest data
I would look at creating a trigger on the table, and having the trigger set to email the inserted rows as appropriate. 

There is no point me explaining how exactly, as Aaron Bertrand gave a super answer to this premise here: https://stackoverflow.com/questions/10755469/send-e-mail-from-a-trigger

I have implemented this sucesfully to send email alerts when certain values change or rows are deleted. Works perfectly.