mailmerge new page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

christophe - 14 Feb 2006 09:06 GMT

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

Signature

\|||/
(o o)
----ooO-(_)-Ooo-------------

Reply to this Message

Doug Robbins - Word MVP - 14 Feb 2006 19:06 GMT

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

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

> Hi,
>
[quoted text clipped - 10 lines]
> regards
> christophe

Reply to this Message

christophe - 15 Feb 2006 07:58 GMT

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

Signature

\|||/
(o o)
----ooO-(_)-Ooo-------------

> Maybe you did it with a catalog (or in Word XP and later it is called
> directory) type mailmerge main document.
[quoted text clipped - 13 lines]
>> regards
>> christophe

Reply to this Message

christophe - 15 Feb 2006 08:23 GMT

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

regards
christophe

Signature

\|||/
(o o)
----ooO-(_)-Ooo-------------

> euh,
>
[quoted text clipped - 23 lines]
>>> regards
>>> christophe

Reply to this Message

Doug Robbins - Word MVP - 15 Feb 2006 11:55 GMT

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

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 tried the Catalog,
> but it doesn't do the trick.
[quoted text clipped - 29 lines]
>>>> regards
>>>> christophe

Reply to this Message

christophe - 15 Feb 2006 12:26 GMT

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

Signature

\|||/
(o o)
----ooO-(_)-Ooo-------------

> How do you want the data arranged on the page(s)
>
[quoted text clipped - 31 lines]
>>>>> regards
>>>>> christophe

Reply to this Message

Peter Jamieson - 15 Feb 2006 12:54 GMT

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

Peter Jamieson

> Doug Robbins,
>
[quoted text clipped - 47 lines]
>>>>>> regards
>>>>>> christophe

Reply to this Message

christophe - 15 Feb 2006 13:24 GMT

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

Signature

\|||/
(o o)
----ooO-(_)-Ooo-------------

> It is possible that you used a DATABASE field in your mail merge main
> document.
[quoted text clipped - 51 lines]
>>>>>>> regards
>>>>>>> christophe

Reply to this Message

Peter Jamieson - 15 Feb 2006 14:19 GMT

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

>I always did use a database field.
> in word it shows {mergefield "adres"}
[quoted text clipped - 61 lines]
>>>>>>>> regards
>>>>>>>> christophe

Reply to this Message

christophe - 15 Feb 2006 15:17 GMT

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

Signature

\|||/
(o o)
----ooO-(_)-Ooo-------------

>I meant a { DATABASE } field, which inserts a table of data from a data
>source into Word.
[quoted text clipped - 71 lines]
>>>>>>>>> regards
>>>>>>>>> christophe

Reply to this Message

Peter Jamieson - 16 Feb 2006 08:55 GMT

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

>I think that this is the case.
>
[quoted text clipped - 97 lines]
>>>>>>>>>> regards
>>>>>>>>>> christophe

Reply to this Message

christophe - 16 Feb 2006 11:01 GMT

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

Signature

\|||/
(o o)
----ooO-(_)-Ooo-------------

> 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
[quoted text clipped - 103 lines]
>>>>>>>>>>> regards
>>>>>>>>>>> christophe

Reply to this Message

Peter Jamieson - 19 Feb 2006 15:52 GMT

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

> I've used "insert mergefield"
> and in that form I could choose
[quoted text clipped - 121 lines]
>>>>>>>>>>>> regards
>>>>>>>>>>>> christophe

Reply to this Message

christophe - 21 Feb 2006 07:57 GMT

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

Signature

\|||/
(o o)
----ooO-(_)-Ooo-------------

>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.
[quoted text clipped - 138 lines]
>>>>>>>>>>>>> regards
>>>>>>>>>>>>> christophe

Reply to this Message