Mail merge with web page

[didijaba]

HI,


I would like to know is it possible to make mail merge with embedded google maps displaying latitude longitude of each record.
Thanks

[macropod]

In a word, no. What you're after would require a macro-driven process that includes retrieving the map. As an alternative, if your data source has the required data, you could insert a hyperlink that, when clicked, would open up google maps displaying the applicable latitude & longitude.

[didijaba]

Thanks for fast replay. So if I understand, I would need way of creating map image with this lat lon and including this image in word doc, using google API and VBA, right? I presume I would have to take and name all images before doing mail merge itself.

[macropod]

Presumably your database contains some info that can be fed into google maps to produce the required display? Ultimately, that info will be translated into a URL (e.g. https://www.google.com/maps/@45,5,15z?hl=en, where 45 is the latitude, 5 is the longitude and 15 is the zoom level or as https://www.google.com/maps/place/ followed by an address is the required format). If so, you would run your mailmerge and output the URL as a hyperlink. Post-merge, you could then run a macro (maybe not even needing the google API) to retrieve the web page display for each URL and insert it with or instead of the URL. I have no experience with retrieving google maps web pages, but you may be able to dig up some code to do so via a web search.