Access mail merge

[kltino]

I currently go to Word and do a mail merge to an Access query. Is there a
module that can be attached to a form that will link to my client query and
allow selections of data? I want others in to be able to use the information
without all the manual steps. Thanks.

 

[Arvin Meyer [MVP]]

If you create a parameter query, the Word user will be prompted.

 

[a a r o n . k e m p f]

that's why it's generally best to store all your parameters in a
database table.

 

[GenlAccess]

Oh, look, he doesn't even know that the purpose of parameters is to let a
user enter what they want. I guess the people who questioned his
intelligence and knowledge may have been right all along. Thanks for the
laugh, Mein Kempf.

 

[a a r o n . k e m p f]

good stuff--- I know exactly what parameters are. you store them in a
table (after the user enters them).

It makes your queries quite a bit better.
Of course, if your database supported 'Windows Authentication' it
would all be possible.

For without it, you're stuck reinventing the wheel.