GMAIL SMTP VBA // Put ''Excel cells-text'' in HTML body

[VBAzr]

Hi everyone,

As I said in the title, I'm able today to send email with GMAIL to customers using VBA.

I'm trying to figure out how to put some, for exemple: Range("C4").Text inside my HTML body.

What I want to do is:

MAIL.HTMLBody =

Company ABC



"Hi Mr. Range("C4").Text ,
" & _
"How are you today?
"

Can someone help me with that?

Thanks in advance!
Vincent