![]() |
#1
|
|||
|
|||
![]() HI, I would like to know is it possible to make mail merge with embedded google maps displaying latitude longitude of each record. Thanks |
#2
|
||||
|
||||
![]()
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
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.
|
#4
|
||||
|
||||
![]()
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Declan | Mail Merge | 1 | 05-28-2014 02:02 AM |
mail merge with 2/3 keys? cant get page break | Lisa274 | Mail Merge | 5 | 01-06-2014 05:13 PM |
![]() |
JWatson | Mail Merge | 1 | 09-29-2013 08:08 PM |
![]() |
Stubod | Mail Merge | 2 | 10-16-2012 12:42 AM |
![]() |
bmobrien | Mail Merge | 3 | 02-23-2012 10:47 PM |