Displaying multiple lines in Word when merging with Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jean-Pierre - 03 Feb 2004 11:44 GMT

I m merging a word document with an Excel doc. I've gone
through the whole mail merger thing. My problem is that I
have include my tags in a table between the header and
footer. It is printing every record on a new page. I would
like to add criteria on when to do the actual page breaks
and manipulation on the recordset.

Thank you !

Reply to this Message

Cindy M -WordMVP- - 03 Feb 2004 23:23 GMT

Hi Jean-Pierre,

It always helps us envision what you're seeing if you mention
the VERSION of Word you have.

> I m merging a word document with an Excel doc. I've gone
> through the whole mail merger thing. My problem is that I
> have include my tags in a table between the header and
> footer. It is printing every record on a new page. I would
> like to add criteria on when to do the actual page breaks
> and manipulation on the recordset.

In order to suppress the new page section breaks you must
select the catalog (directory) type of mail merge rather than
"form letter".

But there's not a lot you can do to otherwise control where
the page breaks occur. Especially since you want the merge
result to be a table. About the best you can do would be to
deactivate the option that allows rows to break across pages.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

Reply to this Message

- 04 Feb 2004 11:42 GMT

>-----Original Message-----
>Hi Jean-Pierre,
[quoted text clipped - 29 lines]
>.
>Tx for the help Cindy. My new problem is that when I

change the merge type to Catalogue, the fields in mjy
header section does not show when I do the merge. What is
strange, is the when I press the button with the arrows
and ABC on it, it shows the fields in the header section.

Cindy told me that I cant really control the page breaks.
I work from and Excel file as my datasource. Now the
fields in the header section correspond to the detail in
the doc, what if for instance the first record has a
different value than the next record?

Thank you !
.

Reply to this Message

Cindy M -WordMVP- - 04 Feb 2004 18:49 GMT

Hi Jean-Pierre

You still haven't told me which VERSION of Office you have?

> My new problem is that when I
> change the merge type to Catalogue, the fields in mjy
[quoted text clipped - 7 lines]
> the doc, what if for instance the first record has a
> different value than the next record?

Yes, this is *exactly* the problem Word has, which is why a
catalog type of mail merge can't deal with merge fields in
the header/footer :-) And why you get "Next Page" section
breaks in a normal merge.

Are you familiar with the StyleRef field (champ)? Look it up
in Word's Help files and read the information carefully. You
should be able to insert the fields into the body of the
document (as hidden text, if necessary), format them with a
particular style, then use StyleRef to display the
information in the header. Place a \* CharFormat switch at
the end of the StyleRef field to make sure it displays with
the text formatting you want to use in the Header.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message