vba to outlook appointment with hyperlink in body

[jasonphillipstx]

I use access to add appointments to outlook. I have constructed a working hyperlink to google maps for the location of the appointment. I have added

Body = "<a href=" & stGoogMap & "> Google Map</a>"

when I display the appointment, it just gives me text, not a hyperlink. However if I use the Clipboard_SetData function to copy the hyperlink and thn just manually paste it, it works fine. I know appointments do not have .HTMLBody but I was hoping Outlook somehow magically make it work. Anyone have any ideas on how to get this working correctly?

 

[Remou]

Would the address without the name suit? That is foreget the <a hfref part and just include the link, because that seems to work.

 

[jasonphillipstx]

I had that working, but I wanted a concise name rather than a long url.