Access 2000/2002 mail merge to Word XP

[Howie Jones]

When I use mail merge in Word XP/2002 it cannot see all of the tables and queries in my .mdb.

None of the queries are hidden.

When I update the database to Access XP/2002 I have the same problem.

Has anyone got any ideas, or is this another 'undocumented design feature'?

Regards

Howie Jones

 

[jimbrooking]

You might have a look at

http://www.experts-exchange.com/Databases/MS_Access/Q_10024700.html

I have used the sample code there to to a mail merge, and it works as advertised. The user interface needs to be tweaked, but if you look on MSDN for documentation on the Work application, you can do pretty much anything you want in your Access VBA code.

 

[Pat Hartman]

The action queries would not be visible and I believe that the parameter queries might also be hidden.

 

[Howie Jones]

Thanks to all.

I thought about doing it in code from within Access but decided to do it from Word as I thought there would be less hassle.

I also think it may be because the query that the merge is based on asks for a parameter.

However, I don't have any trouble running this mail-merge in Office 2000.

I suppose that's the price of progress.