RangetoHTML to paste cell content instead of table with content

Hi all! I am new to this so please excuse any newbie mistakes. I am usually able to find what I am looking for by searching the forums but did not see this brought up by anyone else.

I am using the popular Ron De Bruin RangetoHTML function Ron De Bruin RangetoHTML function to insert Excel cell text as HTML text into a new Outlook email message. I have only changed two lines of code, the rng reference early on to point to a specific named range within my workbook and the PasteSpecial section of the function to help keep the formats intact so I don't think those should affect any potential answer that will be provided. For what it is supposed to do, the code works fine with no errors. But it appears the way it works is to paste the contents within a table into the email body and it can be dragged around the email which is not exactly what I was looking for.

I understand this may be how the function is set up currently, but is there anyway to make it so that the contents of the cell is pasted inline in the Outlook email body (as if I had just copied the cell from Excel, placed the cursor into the new email body and hit paste)? Just to make it easier to reference, I will include the exact code I am using below changing the name of my named cell.

Any help at all would be greatly appreciated!

Please Login or Register  to view this content.

I am all set, figured out the extra space as well. I suppose I should thank you all anyway though. I appreciate the work that is done here and it has helped me countless other times in my amateur coding adventures. Thanks!

I'm in the same boat buddy - do you still have your solution?