Create Google Maps URL using loop (1 Viewer)

[hudson426]

Dear all,

I need some help and advice using VBA to create a URL.

I want to plot several points on Google Maps. The URL I am trying to create is this:-

http://maps.googleapis.com/maps/api/staticmap?zoom=12&size=800x800&markers=color:yellow%7CLS11+8QY&markers=color:red%7CLS10+1AZ&markers=color:red%7CLS11+7HG&sensor=false

String:-

http://maps.googleapis.com/maps/api/staticmap?zoom=12&size=800x800

Variables:-

&markers=color:yellow%7CLS11+8QY
&markers=color:red%7CLS10+1AZ
&markers=color:red%7CLS11+7HG

String (ending):-

&sensor=false

This plots three points on a map. I have created the above manually but I can't figure out how to get access to create it. I have a table that stores address/postcode data:-

[tbladdress].[postcode]

LS11 8QY
LS11 7HG
LS10 1AZ

How do I turn the three postcodes (above) into the url above using vba?

It's basically a string function but I do not know how to loop(?) the three records into one continuous string. I have searched and searched but I can't find the answer. Any help or guidance would be greatly appreciated.

Cheers