Printing to Word from Access in a mail merge template

[Guest]

I have multiple word templates that are already setup to be mail merged with
queries specifically for those templates. I'm not sure how I can run a event
procedure to not only open the mail merged word document but to also retain
connections to the access database in which the queried information is coming
from. Any suggestions?

 

[Guest]

You might care to take a look at:


http://community.netscape.com/n/pfx/forum.aspx?msg=23781.1&nav=messages&webtag=ws-msdevapps


The technique employed is to export the query's result set to text file
which is then set as the source for the merge. The relevant functions in the
basWordStuff module take the name of the query, the path to the text file to
be created and the path to the word template as their arguments. There is an
additional optional argument for determining whether to suppress blank lines
in the merge (e.g. with addresses where not all fields might be used).

Ken Sheridan
Stafford, England

 

[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.

The above also lets you use a query in place of current forms data for the
merge if you please. and it also handles issues of security or connection
problems that tend to crop up when you use word as a template.

about the only change you need here is you'll have to move your documents
into a directory called word in the same directory as where the program file
resides.