inserting a web address into message code

[ben_sorensen]

Hello

I am trying to just insert a link to a website in an email that I am sending in vba. It's just a simple "http:www.lakjehfkashkh.com" but it keeps give me an error

Compile error: Expected: Line number or label or statement or end of statement

any help would be appreciated.

best

 

[paulxmw]

hi

I simply did this code and it worked fine

mBody = "https://www.mrexcel.com"

dont forget to add mBody to the .Body =

Hope this helps