Create a folder in Word on export

[904allen]

I am in the process of created several forms that will merge data to Word
Templates that are legal documents. What I need to do is;

1) look in a defined folder in Word and determine if another folder exist if
not create the folder and name it based on a field on the Access Form.

2) Once the folder is created save the merged.doc as a saveas naming it the
same name as the template or a name from a field on the form, or if the
folder in Word already exist, do a saveas to the that folder, then display
the .doc for possible changes. Also if it is not obvious I’m a newbe. I know
from what I’ve read that #2 is possible its #1 that is a question. Thanks
Allen

 

[Albert D. Kallal]

I have a nice working sample that does a merge of the current record to
word.

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the follwoing page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html

Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Give the above a try.

Furthermore, you can specify a dir name, and it will be created for you.
Unfortunately, the dir name is only relative to current application dir in
which the mdb is running..but that might suit your needs anyway....