Format body in RangetoHTML

Hello experts,

I'm using the Ron de Bruin code to create an e-mail with cells inside the mail body.

Although it runs, I want to add 2 minor changes and I don't find the place to them in the code:

1. The cells lack (only) the lower limit, how can I make it appear or add it?
2. Can Autofit be used? The cells are too long to read the information altogether

Here's the whole code with the function included:

Please Login or Register  to view this content.

I don't know what (1) means.

I have seen requests for (2) but have never seen a solution. My thoughts would be to Autofit your rows and columns first. That won't get you there but might help some. The other thought was to set the Autofit option for the Page settings. To see code to do that, record a macro to print, set your page options, but don't print. Since it is html, an adjustment to the body might help. e.g. http://stackoverflow.com/questions/1...it-to-a-window

Thank you for your kind answer. Thanks to it, I was able to search a lot better. Not the code I need yet, but inside the function i've added:

Please Login or Register  to view this content.

At least on the first cell it works, so know i feel closer to finding the solution.

About (1)., my apologies for not using the proper word. I have borders on the cells, and despite the top, left, right and all interior borders appear, the bottom one does not.

If I copy more than one row to the e-mail, then only on the bottom row is the border missing.

Once again, thank you for your help.

For the autofit, this line of code inside the temp WB of the funtcion solved the problem:

Please Login or Register  to view this content.