VBA and urls

[wmtsub]

I am using vba code to populate the body of an email.
In this line [[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]& "Invoicing with Mercury - https://vimeo.com/274171345 " & vbLf _]
[/FONT]How do I convert this [[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://vimeo.com/27417145[/FONT]] into a url [link]?

 

[onlyadrafter]

Hello,

try

& "Invoicing with Mercury -" //https:/bbc.co.uk" & vbLf _]

put your proper web address in place of BBC

 

[wmtsub]

Sorry, that does not work. Says syntax error.

 

[onlyadrafter]

Hi,

Works for me

.Body = "Invoicing with Mercury -  //https:/vimeo.com/274171345" & vbLf _

Think I may have just spotted the error in the original post.

 

[wmtsub]

tks