Cell value in HTMLBody

[mcinnes01]

Hi,

I am trying to move away from the message body format in my email scripts; to using a HTML body. In many of the email script I have, the email body is personalised or includes data from the spreadsheet. I just wanted to know how I can do this in HTMLBody. I understand HTML at a basic level, just not sure how to refer to cells values in it.

This is an example email body I have:

Please Login or Register  to view this content.

[snb]

Dive into the use of With... End With.

[mcinnes01]

Seem to have learnt HTML quite quickly my only issue now is, I have used <H3> for bold titles, but I want the resulting cell value on the same line but in the body text formating. This has worked my title is Larger and bold and the body text is smaller and not bold, but the body text is on the line below the title and I want it on the same line.

This is an example:

Please Login or Register  to view this content.

after the close </H3> this goes back in to the body text, but it seems to put it on the next row.

DIVISION -
SHRPY

This was my full email in HTML:

Please Login or Register  to view this content.