Mail merge, change parameters query stored in access

[696796]

Hi experts,

i have set up a mail merge in ms word, and have linked it to a query in my access 97 database. Now i want to be able to change a parameter in the query, i.e. CarNo(a number which is unique to each record). How is it best to send this to the query/word document - at the moment it is a query stored in the access database the document is linked to, but how can i get the different CarNo into that query each time?

I can also build the query in vb.net if that would be easier to control the document with?

Any help much apreciated guys and gals,

Al

 

[straybullet]

We had a 2K Access db we did something similar with - we had [Enter Job Number] as the criteria for the field intJobNum.
When the mail merge was started, the Access would prompt for the value of [Enter Job Number] - entering the desired job number would produce the form letter properly.

Let them hate - so long as they fear... Lucius Accius