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:
MessageBody = "MANAGERS DETAILS:" & vbNewLine & vbNewLine _
& Sourcewb.Worksheets("INPUT").Range("MNAME") & " - " & Sourcewb.Worksheets("INPUT").Range("EMP") _
& vbNewLine & vbNewLine _
& Sourcewb.Worksheets("INPUT").Range("JOB") & " - " _
& Sourcewb.Worksheets("INPUT").Range("SITE") & vbNewLine & vbNewLine _
& "DEPARTMENT - " & Sourcewb.Worksheets("INPUT").Range("dept") & " DIVISION - " _
& Sourcewb.Worksheets("INPUT").Range("DIV") & vbNewLine & vbNewLine _
& "HEAD OF DEPARTMENT:" & vbNewLine & vbNewLine _
& Sourcewb.Worksheets("INPUT").Range("HNAME") & vbNewLine & vbNewLine _
& "QUERY DETAILS:" & vbNewLine & vbNewLine _
& Sourcewb.Worksheets("INPUT").Range("YNAME") & " - " & Sourcewb.Worksheets("INPUT").Range("YEMP") & vbNewLine & vbNewLine _
& "CONTACT NUMBER - " & Sourcewb.Worksheets("INPUT").Range("PHONE")
Bookmarks