Adding Named Range to Body of Email

[Turbo68]

What i need to just a simple way to get a group of cells to copy into my body of the email.

I have tried this:

.Subject = "TURN UP " & Range("B15")
.HTMLBody = Range("A15..B21")

And this:

.Subject = "TURN UP " & Range("B15")
.HTMLBody = Range("TURNUP")

But both will not put it in there. I can tell it a cell location like "B15" and it will work but i need more info:

Anyone got a simple fix?

 

[Worf]

Use the range to HTML function shown at post #5 of this thread:


https://www.mrexcel.com/forum/excel-questions/878424-excel-linked-outlook-not-sending.html