View Single Post
 
Old 06-10-2015, 04:15 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote