Email Cell Range via Excel

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)

Alansidman,
Thanks for the response. I tried that link as well, but didn't have any luck. Since I'm only sending a cell it errors saying the source is not a range or cells are hidden. Plus, it seems to be a lot more involved them what I'm looking for. I just want a quick snip of VBA code that will look at the contents of a cell and email it to a defined address. Very simple, but prooving to not be easy. If anyone has any ideas or can provide any help, I'd greatly appreciate it...

NOTE: I am a VBA newbie

Alansidman,
Thanks for the response. I tried that link as well, but didn't have any luck. Since I'm only sending a cell it errors saying the source is not a range or cells are hidden. Plus, it seems to be a lot more involved them what I'm looking for. I just want a quick snip of VBA code that will look at the contents of a cell and email it to a defined address. Very simple, but prooving to not be easy. If anyone has any ideas or can provide any help, I'd greatly appreciate it...

NOTE: I am a VBA newbie

Thanks, I've created a very basic spreadsheet of what I'm looking to accomplish. Basically it's a checklist of items. Once those items are complete, there is a Button that I would like to use that will automatically send an email to helpdesk to open a ticket. The message body of that email will contain the text from a specific cell that is a concatenated formula.

So for instance, in the attached spreadsheet. Somone would fill in the customer name and info...Do the tasks, then click the button to send an email with the message body containing the contents of cell E4.

I'm sure it's very basic, but I'm VBA impaired and could use the assistance. Thanks in advance.