[MikeC]

I am trying to build a mailmerge document where I have a large database (~900
lines of entries) and wish to merge these onto a word document. However, to
save paper when printing, I wish to print maybe 3 entries per page.

Is it possible under mailmerge to call up data from more than one line in
the data table on the same document page? If so how do I do it?

[Lüko Willms]

Am Fri, 6 Oct 2006 08:35:02 UTC, schrieb MikeC
auf
microsoft.public.word.mailmerge.fields :

Is it possible under mailmerge to call up data from more than one line in
the data table on the same document page? If so how do I do it?

I think you would have to set
yourDocument.MailMerge.MainDocumentType = wdCatalog


Yours,
L.W.

[Graham Mayor]

Either triplicate your document on the page and put a next record field
before the second and third versions
or
Enter the document one and set the document type as Directory (Catalog on
older Word versions)


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


MikeC wrote:
I am trying to build a mailmerge document where I have a large
database (~900 lines of entries) and wish to merge these onto a word
document. However, to save paper when printing, I wish to print
maybe 3 entries per page.

Is it possible under mailmerge to call up data from more than one
line in the data table on the same document page? If so how do I do
it?

[Peter Jamieson]

1. create the text and merge fields that you want to insert. Let's assume
that that material occupies one third of the page.

2. Copy the text and merge fields twice

3. Insert a Next record ({ NEXT }) field before each copy (i.e. not
before the "original", so you have

text +fields
{ NEXT}
text + fields
{ NEXT }
text + fields

As for the vertical spacing, you can either
a. adjust the paragraph spacing until you get what you need (but you will
need to make sure that none of your data so large (or small) that lines are
added/removed) or
b. create a 3-cell table with fixed height cells. This is, in essence, no
different from doing a "Label" merge with large labels.

Peter Jamieson

"MikeC" wrote in message
...
I am trying to build a mailmerge document where I have a large database
(~900
lines of entries) and wish to merge these onto a word document. However,
to
save paper when printing, I wish to print maybe 3 entries per page.

Is it possible under mailmerge to call up data from more than one line in
the data table on the same document page? If so how do I do it?

[MikeC]

Thanks for your help guys. I think Peter and Graham have hit the problem on
the head. I had not thought about the "Next Section" idea and I believe that
this will probably cure my problem. I will post again when I have tried it
and let you know.

Many thanks,
MikeC

[MikeC]

Thanks Graham,

I had not thought of that idea and I believe it will solve my problem. I
will let you know how I get on.

Regards,
MikeC

[MikeC]

It worked fine, thanks.
Regards,
Mike C

[MikeC]

It worked fine thanks - DDE was best.
Many thanks,
MikeC