mailmerge new page

[christophe]

Hi,

I've made a mailmerge multi column doc
and a table (foxpro) where all data is stored.
Mailmerge does work but some data doesn't fit
onto one page so I would like to add more rows
when necessary.

I got it working once but I don't know how.
Can somebody tell me how I did this ...?

thanks in advance
regards
christophe

 

[Doug Robbins - Word MVP]

Maybe you did it with a catalog (or in Word XP and later it is called
directory) type mailmerge main document.

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

 

[christophe]

euh,

I changed that setting to something else
because with a catalog type doc
MsWord tells me I can't do mailmerge to email ?

Any advice ?

regards
christophe

 

[christophe]

I tried the Catalog,
but it doesn't do the trick.

regards
christophe

 

[Doug Robbins - Word MVP]

How do you want the data arranged on the page(s)

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

 

[christophe]

Doug Robbins,

I've made a table with 9 columns and 22 rows
this fits apx. on one landscaped page.
with 2 lines of text on top and bottom of it.
But the data is sometimes more then 22 records
can even be 100 or more.
One of my experimenting versions of the doc
added all necessary rows and I'm quit sure
it was something by default or maybe some
property setting.
At least it must have been easy because
it was one of my very first mailmerge attempts.

regards
christophe

 

[Peter Jamieson]

It is possible that you used a DATABASE field in your mail merge main
document.

Peter Jamieson

 

[christophe]

I always did use a database field.
in word it shows {mergefield "adres"}
and this "adres" is a field from my database table.
Is there a different behaviour when connecting
to a database or eg. excel ?


regards
christophe

 

[Peter Jamieson]

I meant a { DATABASE } field, which inserts a table of data from a data
source into Word.

Is there a different behaviour when connecting
to a database or eg. excel ?

No.

Peter Jamieson

 

[christophe]

I think that this is the case.

I use a foxpro table.
but in foxpro "we" make a difference in naming
between a table and a database
a database is rather a tablecontainer which hold the specifications
from one or more tables. A table is the file where all data is stored.

I don't now exactly how this is called in english in MsWord.
but it seems that a table in MsWord is just some kind of
multiple columns and rows.
The name table, i've been using, is maybe wrongly translated
from my dutch version of Word.

So what I've done in my last doc is
insert a table with 6columns and 22 rows.
this table is choosen from the menu.
Then I've opened a database-table and inserted
in each cell of the table-grid a "mailmerge field"
and in the last column in each cell I've added
«next record»


hope this helps

regards
christophe

 

[Peter Jamieson]

Yes, the names are confusing, but the DATABASE field inserts a table of data
that comes from a file, part of a file, or result of a query. (I think the
names are "the same" in Dutch - Database, Tabel).

Peter Jamieson

 

[christophe]

I've used "insert mergefield"
and in that form I could choose
between "database field" or "adres field"
I've choosen "database field" and then
all fields from my table are shown.
Then I've inserted all fields in each cell in
the first row of my table in the word doc.
In the last cell I've added "next record".
Then I copied 21 times that row until the end of the page

But then what ?
How did I do it so the table grows to fit all records of
my database-table. The table (grid) automatically growed
even on multiple pages.
As far as I remember I did "nothing special"...

regards
christophe

 

[Peter Jamieson]

I don't think you will succeed with the approach you are taking because it
only works with catalog merges and you are merging to e-mail.

The word "database" here is misleading. As far as Word is concerned the
"database" fields are the fields as they are named in your foxpro table, and
adres fields are internal names that Word maps to the database fields
automatically when it "recognises" a name that looks like the name of a
common address field such as firstname, lastname, voornaam etc.

What yopu probably did was to insert a { DATABASE } field, as I said before
(use Tools|Customize to show the Database toolbar, then find and click the
Insert Database button. That field inserts a table with headers and
optionally retains the { DATABASE } field so that you can refresh the
results.

Peter Jamieson

 

[christophe]

Thanks Peter,

I overlooked the Database menu.
I will play with it and see where that goes to....
thanks for showing me the different approach.

regards
christophe