errors when merging to Word 1

[crnold]

I am trying to merge data from an Access 2000 query to a Word doc using technique in FAQ181-271. My query gets its criteria from a combo box on a form, which works correctly. When I try to merge, either "pushing" the merge from within Access, or "pulling" the merge from Word 2000, it opens a second copy of Access, asks which query to use for the data, and, if I choose the correct query, brings up a pop up "Enter Parameter Value", with the path to the combo box that gives the criteria (Forms!formname!comboboxname). It does not seem to realize that Access is already open with the correct data in the query.

 

[psemianonymous]

I wrote my mailmerge module to fix the exact problem you describe. Unfortunately it requires coding which may not be the solution you're looking for:

'Native' mailmerge reports - as painless as possible
faq181-5088


The best alternative to my code is to run some action queries to dump the data into a temp table, then have the mailmerge pull the data from the temp table.

 

[crnold]

pseale, I will study your code. I have only as much coding skill as I have had to learn for my apps, so I know a just a little of this and a bit of that, but no formal knowledge. If it is just too much to comprehend, I'll try your second suggestion. Thanks!