I am stumped. I believe I have done everything you said.
Nothing seems to work as I need it to.

1. I need to open a document based on a template from a network location. Is this possible? It cannot be placed in the Templates folder.

Currently I am opening a document by double clicking the dot file. A document opens and asks to link to the SQL source. When I choose Merge to New Document, Letters1.doc opens. This is the document I save. When I open Letters1.doc, it still asks to link to the SQL source, and then it displays the document with the saved data (no matter what the source currently is) If I was to choose File, New, Templates on My Computer, I don't see how I can point to the dot file on my network drive.

2. Once I have Merged to a New document and saved the new document' I don't want to be prompted to open the SQL source when I open that saved document.

3. I am trying to attach macros to buttons that will open a new document based on my template. The macros keep saying "requested object is not available" and yet if I double click the dot file, I am prompted for the data source and a new document opens.

Should I be able to do what I want to do?

Thank you.
Brandi

If you are tired of helping me just say so and I can start a new post.