I have created a command button to email each technician the details of their jobs for the next day. It gives the scheduled time, client's name, address, and contact numbers, and the scope of work required, all in the body of the email. Everything is working perfectly, and as they say, if it ain't broke, don't try to fix it.
That being said, one of my techs gave feedback that it would be nice to click on the address or a link in the email body on his phone, and it brings up the corresponding Google map. For some reason, the phone numbers in the email body show up on their phones as hyperlinks, and will dial the number when they click on it, but neither the Android or Apple systems pick up on the address like they do on the phone numbers. I have tried (unsuccessfully) to turn the client's address into a hyperlink, that will show the address on google maps.
The body of the email is in HTML. Here is the code I was using:
It returns an error message "Expected: End of Statement" and highlights the "https:" in the code line as the point it expects that End of Statement. I even tried creating a string for the url, and putting the string name in place of the whole string, but when you click the link on the email, it is trying to find a website called strUrl.
When I use that line of code in VBA (without the HTML coding), it works perfectly, and finds the client's address on Google maps.
I'm kinda stumped here, and would appreciate any help.
Wayne
That being said, one of my techs gave feedback that it would be nice to click on the address or a link in the email body on his phone, and it brings up the corresponding Google map. For some reason, the phone numbers in the email body show up on their phones as hyperlinks, and will dial the number when they click on it, but neither the Android or Apple systems pick up on the address like they do on the phone numbers. I have tried (unsuccessfully) to turn the client's address into a hyperlink, that will show the address on google maps.
The body of the email is in HTML. Here is the code I was using:
Code:
"<a href="https://www.google.ca/maps/place/" & "+" & Me.StreetAddress & _
"+" & Me.CityName & "+" & Me.StateName>View on Map</a>"
It returns an error message "Expected: End of Statement" and highlights the "https:" in the code line as the point it expects that End of Statement. I even tried creating a string for the url, and putting the string name in place of the whole string, but when you click the link on the email, it is trying to find a website called strUrl.
When I use that line of code in VBA (without the HTML coding), it works perfectly, and finds the client's address on Google maps.
I'm kinda stumped here, and would appreciate any help.
Wayne