I have a large Access db originally created in MSO 2000 and now updated to MSO 2007.
Using MS Word for a mail merge, I use a query within the db as my recipients list. However, when I get to the "select recipients" bit, I point to the db which shows a list of tables and queries to choose from. Problem is, the query I want is not shown. There are only 3 queries listed, when in fact there are 15 or so in the db.
Is there, maybe, something I should be doing in the db to designate my query as a merge source?
Cheers,
Brodie
Using MS Word for a mail merge, I use a query within the db as my recipients list. However, when I get to the "select recipients" bit, I point to the db which shows a list of tables and queries to choose from. Problem is, the query I want is not shown. There are only 3 queries listed, when in fact there are 15 or so in the db.
Is there, maybe, something I should be doing in the db to designate my query as a merge source?
Cheers,
Brodie