merge separate reports

[me04984]

Is there a way to merge 20 reports of 35 pages (with 35 different headings)
and sort the pages so that the headings on each page can be separated and
saved into different folders?

 

[Doug Robbins - Word MVP]

It is not clear from what you are asking if the following will be
applicable:

See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
at:

http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.


--
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

 

[marcia]

I downloaded and attached the Word add-in template. It worked several times
and now it does not work. Something happened to Normal.dot
Help!

 

[Doug Robbins - Word MVP]

What exactly do you mean by it does not work? What does happen when you
execute the merge to a new document? The add-in does not rely on any of the
features of the Normal.dot template.

--
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

 

[marcia]

I did download your add-in, but it did not work all the time. I've also found
that if I select specific people from the database the separate files do not
match the person they are for.

 

[Doug Robbins - Word MVP]

The addin will only work if all of the records are merged or a contiguous
set of records starting with record number 1.

If you need to merge a non continuous set of records, you would need to
first mege them with a Directory type mailmerge main document in which you
have a one row table into the cells of which you insert the merge fields.
You then execute that merge to a new document and then insert a new row at
the top of the table in that document and into that row, insert the field
names. then save that documenta nd use it as the data source.

--
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