Automating Mileage Form

[mattyboy_1984]

Hi, I am wondering if you are able to help me, I am trying to create an automated word documents which take its data from excel to calculate the mileage i travel between clients address just by entering there name, So i would enter client 1 to clients 2 and it would calculate how many miles it was, Is this possible?

I have provide a link to a copy of the mileage form

https://1drv.ms/u/s!AspGJVzkjW3Gj6gf5WeSYtwlJJsuMQ

thank you for you help

 

[ranman256]

yes. You can fill the worksheet, then run a macro to put it in a word doc.
Build a template word doc., then the macro would open this template ,then import the excel sheet.