Recipient Opening a link

[DMT Dave]

Hi Guy's hope you are all good



I need a little help on this one

I am emailing out an address to a shipping company and the end destination contact

all works very well apart from opening the link

if i use links that i am opening myself, i would set IE such as Chrome and Shell Chrome then add URL

However, the link i am sending out i wouldn't Shell anything because if i am correct, i would never know what IE program relevant contacts are using so i am only sending out the link only but doesn't open

is there a short method to change what i have done here ?

Bear in mind for data protection, i have scribbled the address and postcode out.

Const Q = """"Dim strPC as String ' Client PostCode
Dim sEndDest as String
Dim sText2 as String


NOTE: sBoxStart and sBoxEnd is a table setting


sEndDest = "<a href=" & Q & "End Destination:" & Q & "<br>" & "<br>" & "https://www.google.co.uk/maps/dir/" & Replace(strPC, " ", "") & "</a>"


sText2 = sText2 & strHDFS & "<B>END USER / DESTINATION DETAILS:</B>" & strFE & "|" & _
        sBoxStart & "|" & strFS & _
            sDealer & "|" & _
            "&emsp;" & sAdd1 & "|" & _
            "&emsp;&emsp; " & sAdd2 & "|" & _
            "&emsp;&emsp; " & sTown & "|" & _
            "&emsp;&emsp; " & strPC & "||" & _
            sEndDest & strFE & "|" & sBoxEnd & "||"

In the HTMLmail body, I am replacing pipes with "<br>"


Below is the info on HTML Mail Body but the link won't click

[June7]

I think you have the href parts backwards as well as missing characters: HTML a href Attribute (w3schools.com)

sEndDest = "<a href='https://www.google.co.uk/maps/dir/" & Replace(strPC, " ", "") & "'>" & Q & "End Destination:" & Q & "</a><br><br>"

[DMT Dave]

Thank you June7, that certainly opens, i am going to check links like this, i copied from existing code and adjusted the finer details and check where the differences are (href being backwards)

This is now the result and link opens, how can i remove the Quotes at each end of View Destination Details ?

[DMT Dave]

Hi June7, silly me, i think i just need to use Replace on sEndDest in sText2 string, replace "" with nothing

[June7]

Is that what the Q variable is for - quote marks? Don't use them. Remove the concatenation of Q variable.

No, has nothing to do with the Replace operation.