Copy only the words in cell not the entire cell

[Jamesraywebber85]

I have a macro that basically creates an email for me, however there are certain parts that I just want the work from the cell and not the entire cell. The following is the CBA code that I am using.

Please Login or Register  to view this content.

In the body I want it to say "The Customer " & "NAME" & "has requested for you to bring the rental agreement" and then under that in the body I want the Ranges
RangetoHTML(Sheets("TSA Request").Range("A16:F16")) & RangetoHTML(Sheets("TSA Request").Range("A19:F19")) & RangetoHTML(Sheets("TSA Request").Range("A4:F4")) & RangetoHTML(Sheets("TSA Request").Range("A5:F5")) & RangetoHTML(Sheets("TSA Request").Range("A9:F9")) & RangetoHTML(Sheets("TSA Request").Range("A7:F7"))

The issue is when it creates the email, it puts an extra line below the info request to generate this email. I would like for the agent to click on "Bring Rental Agreement" hyperlink which currently opens an email template, but rather it generate this email for them. Any help would be greatly appreciated. i have also attached a copy of my workbook for any assistance that you can provide.