VBA

Each day excel spreadsheets are emailed to outlook addresses in the company. I would like to have a macro set up that will email certain excel spreadsheets (10 in all, all different spreadsheets to various email addresses). I would also need the spreadsheets to be value pasted when they are emailed out but not obviously the original. How can you do this ?

Thanks

Jason