code to compose outlook mail with the excel data

Hi all,

Need all your possible help here to achieve the below requirements,

I have certain data in excel which i need to get copied in outlook compose maiil.....

Below is the data i have in excel file, attached excel file for reference.

S.no Name Emp ID To CC


Requirements are,
Excel file has 4 rows of data,
1) upon executing macro, i want macro to copy paste these data in the compose mail of outlook and ready to be sent.
2) if i add new data , along with the 4 rows already available..... then upon executing macro, it should copy paste only the newly added data.....it should not consider already taken 4 rows of data. should copy and paste only the new data.

These two are my requirements.
How i do manually now is, i copy past existing 4 rows of data and send mail. After sending the mail..... i update the very last column as "Sent"
so when someone adds data, that will the blank in the last column. So I filter and take only blank in the last column, which means not sent data.
Then i filter and copy visible data. Then i mark those data as "Sent" at the last column.

Thats how i do manually.

Is there any way i could achieve all this copy past in outlook and flag the already copied data as "sent" via vba code.

Please help.