merge separate reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

me04984 - 19 Feb 2008 13:00 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 19 Feb 2008 20:03 GMT

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.

Signature

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

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

Reply to this Message

marcia - 20 Feb 2008 18:06 GMT

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!

> It is not clear from what you are asking if the following will be
> applicable:
[quoted text clipped - 13 lines]
> > and sort the pages so that the headings on each page can be separated and
> > saved into different folders?

Reply to this Message

Doug Robbins - Word MVP - 21 Feb 2008 05:48 GMT

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.

Signature

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

>I downloaded and attached the Word add-in template. It worked several times
> and now it does not work. Something happened to Normal.dot
[quoted text clipped - 20 lines]
>> > and
>> > saved into different folders?

Reply to this Message

marcia - 21 Feb 2008 13:02 GMT

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.

> I downloaded and attached the Word add-in template. It worked several times
> and now it does not work. Something happened to Normal.dot
[quoted text clipped - 17 lines]
> > > and sort the pages so that the headings on each page can be separated and
> > > saved into different folders?

Reply to this Message

Doug Robbins - Word MVP - 21 Feb 2008 22:45 GMT

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.

Signature

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

>I did download your add-in, but it did not work all the time. I've also
>found
[quoted text clipped - 29 lines]
>> > > and
>> > > saved into different folders?

Reply to this Message