Calculate Distance using Google Maps

Hello Everyone,

I am trying to calculate the distance between two cities in excel using google maps. IS this something that can be done ? Please advice.

Here is an example of what I am trying to do.

Address 1 Address 2 Miles
Atlanta Dallas 1000
Houston Laredo 200

So basically I need a function in column 3(miles) which calculates the distance between address 1 and address 2.
Do I need to write a macro for that or can this be done simply by adding a new function in the cell ? Please advice.

I appreciate your help.

Thanks
Jay