Copy from excel and paste in Outlook New Mail

Is it possible for me to copy columns A to F based on date and paste it into a outlook new mail window and send it automatically, at the end of the shift or when the user closes the excel file,and aslo lock the cells so that the user cant make any changes to that next day. I am attaching the sample file also.

Try the attached sheet. If you plan to run this unattended you will need a program called ClickYes (Free download). If you don't use this program then Outlook will just sit there asking for confirmation of "A program is trying to send email on your behalf. Do you want to send this?"

Let me know if you need anything clarifying

John

Date should be todays date, its like a report send to supervisor at the end of the shift. so it should copy only information for todays date.I didnt want the file to be attached as file, but i just wanted the data to be pasted into the new mail.