open queries and mail merges

[Ilan]

hello,
I have an open query which asks the user to input
month and year (in format ##/####) for when individuals
join a particular professional organization.
Basically in my criteria for the query i use the [ ]
operators to prompt the user for to imput a month and
year.
Now, i use a RunApp Macro to send the results of the
query to Word for a mail merge. However, when i am
setting up my main document, i cannot select my query
because it is not listed.
I believe it is not listed because it is an open
query. I am using Access and Word versions 2002 and i
found that it worked successfully in office 2000.

Does anyone have any solutions on how to get this to work?

Much appreciated,
Ilan

 

[Albert D. Kallal]

One solution is to prompt the user, and then generate the data for the user,
and then merge on that.

I have a solution that should work in your case (and does all of the above
automatically for you), and thus eliminate the problem of word not seeing
the query.

Give my sample word merge download a try here:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html