Merge all records - command button on form

[Guest]

With very clear instructions provided at
http://www.members.shaw.ca/AlbertKallal/wordmerge/index.html, I created
various word templates in Access to merge individual records into word with a
Single merge (this record) command button.

Now I'd like to add another command button (just as in his sample database)
that merges all records flowing from the query. I can't find any
instructions to do so. It seems like it should be easy but I cannot figure
it out. Please instruct.

 

[Guest]

Try this

http://usenet.p2preactor.com/index-t-1473958.html

 

[Guest]

Thanks but none of the exchanges contained within was helpful. Any other
recommendations.

 

[Rick A.B.]

With very clear instructions provided at http://www.members.shaw.ca/AlbertKallal/wordmerge/index.html, I created
various word templates in Access to merge individual records into word with a
Single merge (this record) command button.

Now I'd like to add another command button (just as in his sample database)
that merges all records flowing from the query. I can't find any
instructions to do so. It seems like it should be easy but I cannot figure
it out. Please instruct.

Karen,
This is how I do it.

MergeNoPrompts "Letter.Doc", "c:\student\Letters", True, , ("select *
from qry_1_Letter")

Hope that helps
Rick