Office 2003.Word Mail Merge from Access Parameter Query. Possible?
Posted on 2006-05-25
I use Office 2003 Pro. I wish to create a mail-merge letter in MS Word that gets its data from a parameter query in Access 2003. The query I wish to use, prompts users for a start membership numbe, End membership number and betwwen first and last date and brings up the data within the constraints of their input.
If I use the mail-merge wizard in MS Word to link to the database, it shows all the queries EXCEPT those that require user input for the parameters.
Is it not possible to create such a mail merge with parammeter input. So far I have had to create a normal query and change the criteria section in the query design. This is long a laborious and I often forget to do it before running the query
What am I doing wrong? Is it possible to do a mail-merge with a query that requires user input for its parameters and if so how as I have tried every option in the Word Mail Merge Wizard to no effect