How do I set the address of a Hyperlink variable?
Dim strUrl As String
Dim hyper_Url As Hyperlink
strUrl = "https://www.google.com/maps/dir/
hyper_Url.Address = strUrl '<------ this line errors out
What I'm trying to do
Build a URL for Google Maps direction.
I can load the URL as a string in a browser, but when I try to send it in an email the email recognizes the first part of the URL and not the addresses I add. So the user clicks on the URL in the email and doesn't get the map. My thought is that if I had a Hyperlink variable to the email, it will work.
Thanks in advance for any help.