Select All Populated Cells for StrBody

[Wheelie686]

I have the following code that attaches a workbook with Sheet(1).Range("E1:N9") in the body of the email. However I'd like to add column A of the 2nd sheet as regular text after my RangeToHTML. I thought strBody would be the solution, however it's only adding the last populated row in column A instead of ALL populated rows. Column A would have a minimum of 1 row(s) but could have many more after. I'm sure it's just a typo that I can't think of how to fix.

Ideas?

Please Login or Register  to view this content.

[6StringJazzer]

StrBody is explicitly getting the last row of data in A. You need to set up a loop to build up StrBody, maybe something like this:

Please Login or Register  to view this content.

I don't know how you want it formatted, though.

[Norie]

All this is going to return is the last value in column A on the 2nd sheet.

Please Login or Register  to view this content.

If you wanted to handle an entire row you would first need to return that row in the code and then process that row to produce valid HTML.

Even then it might not be enough to simply tack that on at the end of the HTML returned by RangeToHTML.

What I would suggest is copy E1:N9 from the first sheet to a blank sheet, copying the last row from the second sheet below that and then passing that range to RangeToHTML.

[Wheelie686]

Thanks 6StringJazzer! That works however I'd like it to put a carriage return between each cell contents. Right now it just comes out as a run-on sentence.

[6StringJazzer]

You said "regular text" so I wasn't sure what you wanted. Since you are using HTML format try this:

Please Login or Register  to view this content.

[Wheelie686]

That's perfect! Thanks very much.