Hyperlinks with VBA

[trixxnixon]

msg = msg & "<br>"
msg = msg & "<br>"
msg = msg & "<br>"

i am formatting an email for outlook, that my database sends when a customer submits something.

given the example above, how might one insert a hyper link into the text? i have tried the usual Href, but i keep getting syntax errors.

any ideas?

[Megalog]

Something like:

strHyperlink = "<A HREF='" & strAddress & "'>" & strHyperlinkTitle & "</A>"

where strAddress is the web address, strHyperlinkTit le is the displayed hyperlink text, and strHyperlink is the resulting string that you'd drop into your procedure.