Microsoft Office Tutorials and References
In Depth Information
Mail Merge: Creating a One-to-Many List
these offer an alternate path that makes it comparatively easy for a user to set
up the main merge document, while VBA code behind the scenes does the
actual list building.
With this tool, it is possible to specify a table of data containing lists of information
related to the individual merge records. The record-specific data is extracted as
each record is processed and inserted into the merge result for that record.
Figure 59 – Document Layout
The list of class grades in this mail merge result was generated by querying the
database for all the grades belonging to the current merge record (pupil), as it
View the Appendix to learn how to store this procedure
in a Standard module.