Auto email from excel

Auto email from excel

Good afternoon everyone!!

I have seen one example of excel that suited to data that we need wherein it sends an automatic email thru microsoft outlook. The file is ok but there are only two things that we need to change when sending an email, the sample file shows the notification message as email body. What we wanted to have is:
1. To send the whole row that have no date forwarded yet (see screen shot in sheet 2) to be as a body of email.
2. This file will be send to two specific email address only– maybe we can include the email in second sheet or any where from the file. And we can assign the cc and bcc inside the macro.
I am not that good in macro that is why we only get samples from internet.

Thank you all in advance and have a nice day!!