Google map links

Hi Andy, thanks for the query. First of all you need to make sure the datatype of the postcode field is changed to hyperlink. That will change your postcodes to blue and underlined. Right click on each postcode and Edit Hyperlink, changing the address to (in the case of WC1A 2LP):

http://maps.google.co.uk/maps?q=WC1A +2LP

The result will be a postcode hyperlinked to the corresponding Google Map. Now I know your next question is "how do I do this for hundreds of postcodes?" The answer is with a macro. You can record hyperlinking one postcode in this way, then edit the code acordingly and get the computer to loop through each postcode. We can come up with this at the end of the Advanced course if you like, or else give the office a call and we'll generate it for you if you run into problems.

All the best,

Anthony