Mail Merge Hell

[AnnPhil]

How do i get a Word Mail Merge document to recognize a field in a Access form as the criteria for the form letter. Example, i have a form with several records i want to print a contract for just the current record. I base my Word mail merge on a query so that it will look at the contract id on the current record and print me a contract. However, everytime i run the mailmerge it still prompts me for the contract id. Once i type in the number the merge works fine. I would just like to eliminate the prompting for the contract id. I thought building a query with just the fields needed for the contract and putting in a critieria that would tell which record to print would be enough.

This is the critieria in the query [Forms]![formName]![ContractID]

Any suggestions??

 

[AChir]

It may be clumsy but how about making your query a make table query and then basing your word data source on the table?

I have used this and it seems to work OK

 

[Fizzio]

2 things to look at
1) if the query refers to a from, make sure that that form is open
2) is [ContractID] the name of the field or the control on the form. It should be the name of the control.

HTH

 

[AnnPhil]

Fizzio, thanks for replying and yes to all your questions.

AChir, i will try the make table approach, that should work.


I will let you know how things work out.