Question
How do I set the address of a Hyperlink variable?
Code
Dim strUrl As String
Dim hyper_Url As Hyperlink
'Start URL
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.
The Whys
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.
LJG