You mention three different queries, a single mailmerge main document can be configured to process one query (to implement conditions that apply globally), and field coding, via IF, SKIPIF fields and the like can typically be used to do the rest. Or, if you want tabular output, DATABASE fields can be used to run their own queries (even against different data sources). No VBA or post-merge document consolidation required. These approaches all work with any Office version and, once the initial configuration is done, should be easy for anyone to use.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|