Send Range of Cells as an Attachment

I have a worksheet designed as a form that I update and email to an external agency quite regularly. The basic premise is a button that when clicked saves a range of cells into the body of an email then sends to said agency.

I am currently using the following code:

Please Login or Register  to view this content.

Instead of sending the cells in the body, I would like to send thenm as an attachment.

The attached workbook is an example of the cell range plus an explanation of what I need.

Hi,
you might find help at Ron de Bruin's page

I would do but I dont know how to tailor it to my situation. I have a user form to input data. When I press submit the data from the userform populates certain cells within a range. with regards to the code on ron de bruin's page, how would I incorporate that into the code I have for the Submit button? Code below.

Please Login or Register  to view this content.

Ron's code is for attaching the range as a workbook. In my situation, I am unable to send .xls documents.