No thanks, I will pass! If you were stuck with something, I would pitch in, but I don't do demands for free services! Record a macro of what you want done! It is that simple. As for the email, no email server will accept an excel file without first compressing it (zip). Why don't you use powershell to send the mail (after you have zipped it up!). It is as simple as :
Send-MailMessage -To "Someuser@emailserver.com" -From "email@example.com" -Subject "Zipped Excel" -Attachments "C:\NEW\thefilenameishere.xlsx"
I got bored waiting for updates, so I recorded a macro:
ActiveWorkbook.SaveAs Filename:="C:\NEW\thefilenameishere.xlsx", FileFormat _