My VBA skills are very limited and I'm hoping to get some help from the more advanced users out there.

I have a spreadsheet that that will be used as a provisioning checklist. As the tasks in each section are completed in the checklist, I placed Form_Button at the end of that section that I'd like to use to automate an email with contents from a few concatenated cells.

As my reference I'm using this MS article: http://support.microsoft.com/kb/816644
(NOTE: I'm using this code almost exactly as it's posted, I've only changed the email to field and the range to pull from)

Problem is, the code isn't sending the range specified, it sends a badly formatted version of all cells in the worksheet.

Ideally I'd like to have the spreadsheet help automate the steps of the provisioning process. I have everything in place, I just need this last piece (VBA email macro) to send an email with the information inside a couple of cells. (Note: the cells are just a concatenated formula summarizing key points).

Any help someone can provide is greatly appreciated.

(NOTE: I'm using Excel 2013)