[VBA]HTML Email Body: How can I edit the format of added cell value?

[ReventonKing]

Hello Guys!

I have a code that creates an email. I need to address all the people by name, so I wrote this code:

strbodyhi = "< BODY style=font-size:11pt;font-family:Calibri >Hi & Sheets(29).Range(Cells(inter,22).Value" < /BODY >"

The result is this:
"Hi" & Sheets(29).Range(Cells(inter,22).Value"

Then I modified the code to this:

strbodyhi = "< BODY style=font-size:11pt;font-family:Calibri >Hi < /BODY >" & Sheets(29).Range("V" & inter).Value

The result of this is:
"Hi
Gréta"
So the added cell is not be in the same setup format, nor it is in the same row as "Hi"

Please help, thank you.

 

[Andrew Poulsom]

Does this work for you?

strbodyhi = "< BODY style=font-size:11pt;font-family:Calibri >Hi " & Sheets(29).Cells(inter, 22).Value & "< /BODY >"

If not post what does work with a constant for the name.

 

[ReventonKing]

It worked, thank you very much!!