How to pass a variable in VBA to HTML code?

Question

I am using Excel VBA to generate an email in Outlook.

I would like to pass a variable value to the HTML code I am using to generate emails. The HTML code is lives in Sheet1!$A$1

How can I pass a variable value from a subroutine to the HTML code? I don't want to write out my HTML code in a module as writing it in VBA is painful!

VBA

Sub foo()
Dim myCustomVariable as string
myCustomVariable = "John Smith"
End Sub

HTML in Sheet1!$A$1

<html>
<body>
<p>Hello "myCustomVariable "</p>
</body>
</html>

urdearboy · Accepted Answer · 2020-04-14 01:03:40Z

1

Concatenate your tags and variables with &

.HTMLBody = "<p>" & Sheets("Sheet1").Range("A1") & "</p>"

answered Apr 14, 2020 at 1:03

urdearboy

14.6k6 gold badges35 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to pass a variable in VBA to HTML code?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related