VBA code for save and attach to outlook

Hi There,
I need your help in a big way. I created an excel timesheet “Macro –Enabled template” for my company, and I need a vba code for it to save and emailed by outlook as the attachment to program manager for approval after click the submit button. Employee’s last names are on A50:A60 and managers emails are on B50:B60 with one to many relationship. When A4 the employee’s Last Name filled then will auto linked with the email of the manager for emailing.
Is this possible to be done? I am using MS Office 2013. Thanks.

JJ

Here is a link to step-by-step guides to create Excel Email macros.
Ron de Bruin Excel Automation: Mail from Excel

This is probably the specific macro you want
Mail the whole workbook from Outlook

Thank you AlphaFrog,
1st question, can I combine both VBA code into one action, save first then send email as the attachment?
2nd question, how to use the employee's last Names to auto link the manager's email?
Thanks.

JJ

AlphaFrog,
Thank you so much. It works very well for my need, only if you can help me to add the submit button code onto your vba code (I used the 2nd sample on your web site). Again, thanks.

JJ