Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Automated Task


  • Please log in to reply

#1
mikeeje

mikeeje

    New Member

  • Member
  • Pip
  • 1 posts

Hello. I get frequent updates from my employees by email that includes latitude and longitude coordinates. I am trying to figure out if there is a program/service that will automatically pull the lat/long from my email and plot it on a google map. I can probably figure out how to use google fusion to plot the coordinates to google maps, but I don't know how to have the coordinates automatically pulled from my email and put into a spreadsheet for google fusion. Or maybe there is a better way than a fusion table. I have a Windows computer at work and a Mac at home, so I can do it on either platform. I can use Exchange or Gmail. Thanks!


  • 0

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP

i don't know of any native ways to do it. but I do know there are some apps out there that can parse your email for specific formatted text. probably even easier if the email is always in the same format and always has the info you're looking for in the same place

 

https://mailparser.i...email-to-excel/  that's just a quick google search result. definitely not the only result.

 

http://www.slipstick...e-message-text/ here's a bit about using VBA in outlook. will take some combining with other scripts and such to get the data out into excel, but it seems to be able to do such a thing based on the comments. would likely benefit from having a SPECIFIC email address used JUST for the gps info.


  • 0

#3
nikitanewton

nikitanewton

    New Member

  • Member
  • Pip
  • 3 posts

If i am clear, you need to put all the e-mail list of your customer from the google to spreadsheet. A software can help you to Synchronize, i selected software which is integrated with google which can Synchronize Task, calendar, E-mail, notes all the details ( It gave me a complete solution).


Edited by nikitanewton, 16 April 2016 - 03:25 AM.

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP