OK, we create "Letters of Acceptance" using the same template multiple times a day, I have designed an excel spreadsheet that has all the fields necessary and a word document linked to this that is formatted exactly how we need it. You fill in the details in the excel form, load up the word document and voila! all the fields are there and correct.

Then the problems start, I need now to save this document as it is, under a different file name. But so that when it loads up it doesn't look for the linked information. It's no use just saying "never click on the update linked information button" as the people using it will do this regardless, and then the document will update to whatever is in the excel spreadsheet. Any ideas? email me and I will gladly send you the two documents! Thanks for your time, hope someone can help! [email protected]

Even better would be having the excel spreadsheet generate the word document by clicking a "generate" button then asking for a file name?! Possible? Considering the format of the word document is fairly intricate and important? Could excel update a template in word then save it under a filename specified in the excel spreadsheet?

Please help me excel gurus!