Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-26-2016, 04:48 AM
didijaba didijaba is offline Mail merge with web page Windows 8 Mail merge with web page Office 2010 32bit
Novice
Mail merge with web page
 
Join Date: May 2014
Posts: 5
didijaba is on a distinguished road
Default Mail merge with web page


HI,
I would like to know is it possible to make mail merge with embedded google maps displaying latitude longitude of each record.
Thanks
Reply With Quote
  #2  
Old 01-26-2016, 02:13 PM
macropod's Avatar
macropod macropod is offline Mail merge with web page Windows 7 64bit Mail merge with web page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,379
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 01-26-2016, 02:43 PM
didijaba didijaba is offline Mail merge with web page Windows 8 Mail merge with web page Office 2010 32bit
Novice
Mail merge with web page
 
Join Date: May 2014
Posts: 5
didijaba is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 01-26-2016, 03:29 PM
macropod's Avatar
macropod macropod is offline Mail merge with web page Windows 7 64bit Mail merge with web page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,379
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge with web page Split each page of mail merge into separate pdf 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
Mail merge with web page Getting Mail Merge to Start new page JWatson Mail Merge 1 09-29-2013 08:08 PM
Mail merge with web page mail merge 3 entries on one page Stubod Mail Merge 2 10-16-2012 12:42 AM
Mail merge with web page mail merge multiple recipients per page bmobrien Mail Merge 3 02-23-2012 10:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft