Q: Access, Word or what?
> I just wanted to compliment you on the great job you've done on your VB
> site. I was very impressed by the wealth of knowledge you've gathered.
> We are just getting into the VB arena and it's comforting to know that
> resources like your's are available.
> We want to be able to build a front end to MS Word where the user will
> query an SQL Server database to retrieve customer information (name,
> address) then launch Word and automatically fill a template with the
> query results. At the same time maintaining an archive of these
> documents, organizing them by customer for later reference. The user
> would have no control over document naming conventions as well as
> placement. Just a simple query, fill out, print, save, and the ability
> to access for future reference. Is this possible?
Kaznowski, Ron; rkaz@enia.com
A:
Ron, everything is possible (if you have time and money ;-)) but I 
have made an application which uses a MS Access database; get some 
records and/or fields (chossen by the user) and then use word to 
print it in a template (in my case an order to pay). Ms Word is used 
transparent.. it will not be opened for the user so they cannot make 
any changes. It is very simple (the basics). By changing some command 
you can save the result in a location of your choice:

In the example (MailMerge.zip) you can change the line
xWord.SaveAs strPath & strNAW into anything you want.
I suggest you take a look at the example. it is easy to understand 
it.

For later use you can store the filename into a database. This way 
your users can easily access the files. 

Return