[MaxArk[_23_]]

I have an Excel based user friendly application that processes a dataset
for use as source data for a mail merge document in Word.

To maintain the user friendliness (ie as little user knowledge and
interaction required) I am wondering how, if at all, I can accomplish
the following:

1) I can launch word and the Word merge document from excel, but how can
I return the user from Word back to Excel once the mail merge document
has been prepared? (without needing the user to actively participate in
closing windows and maneuvering others.

2) Automatically prepare the mail merge document, skipping the "Main
Document Setup". ie an Excel button launches the mail merge document
based on the criteria saved with the document and goes straight into the
final document preparation. No need for the user to press the "Merge to
new document" button.

3) Automatically assign the newly created document a file name and save
it after review by the user.

4) Return the user back to Excel where they left it (which may be in the
middle of a sub?)

Jenn




--
MaxArk