Mail merge for filtered results

[har273]

Hi thanks in advance.



This is the first time I am trying to do mail merge from access.

Actually I have a query and I have designed the letter template in Ms word.
Now I want to filter the query based on the data passed from the access form and merge the filtered data in Ms words mail merge.
Can Any one guide me how to do this.

Any help will be greatly appreciated.

many thanks.

[Stingaway]

The only way I can think of to do this in a static environment (i.e. someone using Word but does not have MS Access open at the time of the mail merge) is to have a static table created by the form before the mail merge is run.

If you want to do it dynamically, the form would always have to be open and the date in the form always populated... I suppose you could call the merge from the form - or for that matter you could do a merge through Access reports. Not as pretty and a bit more time to set up, but it works...