Code to email range and attach file

[ardykav]

Each week I have to email a range (C14:H42) of an Excel sheet in the body of an email but also attach the whole file.

I have Office 2013 which makes this task a little annoying. Would anyone have some VBA code that could automate this for me?

thanks