Combine multiple merges into one document

[kaufmed]

I have written an app in access to accept bio data for individuals. This
data is sent to word for merging. The catch: I have 60 different letters to
which the data can be sent--depending on which letter the user selects for
the individual. I want to capture the resulting merge for each letter type
and merge the letters into one master document that the user can
review/print. Any advice will be most welcome. Thank you.

 

[Doug Robbins - Word MVP]

It is not clear if you are merging multiple records to each selected letter
and whether it is by each record that you want to combine the resulting
letters, or whether it is just one record at a time that is being merged to
multiple mailmerge main documents.

Also, how does the user select the letters with which the data is to be
merged?

There's no doubt that what you want can be done, but it is not clear exactly
what it is that you want.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?a2F1Zm1lZA==?=,

I have written an app in access to accept bio data for individuals. This
data is sent to word for merging. The catch: I have 60 different letters to
which the data can be sent--depending on which letter the user selects for
the individual. I want to capture the resulting merge for each letter type
and merge the letters into one master document that the user can
review/print.

I think I follow what you intend. My advice would be to provide a form with
checkboxes. The user indicates by clicking the checkboxes which separate
documents he wants to use.

The code then starts with a single document created from a template attached to
the data source. Using Insert/File it inserts each required document, which
already contains merge fields. The mail merge is then executed - the "master
document" is the result.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail