Auto email when excel file is updated

Good day every one..

I have one excel file that i wanted to be set up using macro, honestly i have no idea how to set it up thru macro. My plan is to create a file that will sent auto email using microsoft outlook.
1. auto email will trigger once the data is updated
1. Email will send the screen shot of the whole data
2. once send, it will no longer be included in the next update
3. there is a column in the data that automatically shows the date when it was sent

Shortly, all rows that are no date sent will be the attachment to email including the title subject

Please see attached sample, thank you all in advance for the help.