Access: Button to Print Merged Documents from Query

[neodba]

Hello. Please forgive my newness to the Forum and to Access, but I did not see this question answered anywhere.

From a button or menu option, I want the user to be able to run a query to gather a group of records, and print a merged set of Word letters or labels from it. The query and letters are pre-existing, as is the label template.

I'm new to Access and don't have time to absorb VBA. Could this be done with a Macro? Do you know of a succinct (preferrably no-cost) resource where I can get some examples to try?

Thank you.

 

[AlexCuse]

Do you mean you are trying to run a mail merge in word, through access? I have a function for that around, but it requires changes to the user's registry to run (if you are using Access 2k3). It also has gotten rather slow since we switched to 2003, not sure why yet. Hasn't been a high priority.

You would have to change it from saving the mail merge as a file to printing, but that would be trivial.


Ignorance of certain subjects is a great part of wisdom

 

[neodba]

Thank you Alex.
I'm a little hesitant to change their registry. What's your suggestion?