Create Program: Take Excel Address to Google Maps Directions to Letter (NO DATA ENTRY)

OVERVIEW:

This project will require the selected programmer to create a mechanism/program to (1) take list of my client's addresses (always in the same format and sample included below) from Excel and (2) create turn-by-turn directions (distance as well) using Google Maps for each address to a particular location (static location/ my office) and then (3) merge those turn by turn direction into a unique letter (word format) for each client.

GOAL:

I am trying to avoid having an employing take each address (one at a time) and enter it into google maps, copy the directions from google maps and then paste and format into word. The list can be as long as three hundred names per day! This needs to be automated.

DATA:

- Client address are always in the exact same format in the excel spreadsheet.

- The ending address is always the same (my office)

- Directions will need to placed into a letter that should be in word format / template

- Letter should contact turn by turn directions (hereinafter referred to as "Produced Directions")

- Letter should contact distance from client's address to ending address. (hereinafter referred to as "Produced Distance")

FORMAT:

- The merged word template must be editable

- The process to complete this task should be simple or at least straight forward and be automated.

- I have included a sample excel list for you to review to see where the information is coming from and the format it is in. The format of this list CAN NOT change.

Przetwarzanie danych Excel Google App Engine Architektura oprogramowania Word

Numer ID Projektu: #4972796

O projekcie