Using mail merge to generate tables without page breaks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gail Gurman - 24 Mar 2008 21:53 GMT

I have an Excel spreadsheet, and I need to convert each line into a formatted
table in Word. I've been using mail merge to do this, and the tables generate
perfectly, but each is followed by a page break. I don't want anything
between the tables other than a paragraph break, but I can't figure out how
to get rid of the page breaks (other than manually deleting each one, which
is not practical because there are 360 tables).

Any advice?

Reply to this Message

macropod - 24 Mar 2008 23:37 GMT

Hi Gail,

You can replace all the section breaks via Find/Replace.

In the Find box, input: ^b
Leave the Replace box empty or, if you need to replace the section break with an empty paragraph, insert: ^p

Cheers

Signature

macropod
[MVP - Microsoft Word]
-------------------------

>I have an Excel spreadsheet, and I need to convert each line into a formatted
> table in Word. I've been using mail merge to do this, and the tables generate
[quoted text clipped - 4 lines]
>
> Any advice?

Reply to this Message

Doug Robbins - Word MVP - 25 Mar 2008 09:34 GMT

Change the main document type to a catalog or in Word XP and later it is
called directory type and make sure that after the table in the document you
have two (2) paragraph breaks ¶ and nothing else.

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 have an Excel spreadsheet, and I need to convert each line into a
>formatted
[quoted text clipped - 8 lines]
>
> Any advice?

Reply to this Message

Rate this thread: