VBA hyperlink

[Homegrownandy]

Hello,

Below is code I'm using to generate links to job locations in the business. Problem is, when the postcode has a space in it, the link cuts off short.

I can easily rectify this by removing all spaces, but I was wondering if I can define the whole thing as a hyperlink?

  
               .Body = vbCrLf & "Map: http://www.google.com/maps?q=" & Me!Postcode & "+UK"

[jwhite]

If you use .htmlbody instead of body, then you can build the whole link:
.HTMLBody = "<br>Map: " & "<a href=""http://www.google.com/maps?q=" & Me!Postcode & "+UK" & ">" & "http://www.google.com/maps?q=" & Me!Postcode & "+UK" & "</a>"

In theory that should work.

[orange]

I haven't done this for a while, but the routine I used has the following

...sQuery = "http://maps.googleapis.com/maps/api/geocode/xml?sensor=false&address="
50    sQuery = sQuery & Replace(sAddr, " ", "+")
...

It replaces spaces in the evolving URL with a "+"

Good luck

[Homegrownandy]

Thanks both!

Took some time, but I've got it. Its almost like I know what I'm doing.