Genx Posted February 12, 2007 Posted February 12, 2007 Hi Guys, Let([ Initial_Street = YourStreetfield; Initial_Suburb = YourSuburbField; Initial_PostCode = YourPostCodeField; Initial_State = YourStateField; Initial_Country = YourCountryField; Dest_Street = YourStreetField; Dest_Suburb = YourSuburbField ; Dest_PostCode = YourPostCodeField; Dest_State = YourStateField; Dest_Country = YourCountryField ]; "http://maps.google.com/maps?f=d&hl=en&saddr=" & //Initial Address Substitute(Initial_Street & ", " & Initial_PostCode & ", " & Initial_State & ", " & Initial_Country ; " " ; "+" ) & "&daddr=" & //Dest Address Substitute(Dest_Street & ", " & Dest_PostCode & ", " & Dest_State & ", " & Dest_Country ; " " ; "+" ) ) Fill in the blanks in the let statement above and it should give you the correct url.
Recommended Posts