Automating a Word file with Access

The order desk girl has a letter that is in Word with Merge data retrieved from a table in an Access Database. With the upgrade to Office 2003, the merge feature is setup a bit differently which then confuses her.

There are two fields that she filters by. The first one called “Letter” should always find records with “yes”. The second field called “Date” is a specific date that then narrows down the data to one or 2 records.

In order to simplify the whole thing I want to automate it so that when she opens her letter in Word, it asks her for the date and then automatically filters the records and merges her data.

So, what is the easiest way to do this? Within Access or within the Word document? And how do you recommend doing it? The table by the way is called “Table1”.

Thank you.
Tink