Publisher page breaks

[Dave Melosi]

I am importing files from an excel spreadsheet.to make a report. The report
will be different lengths. Depending on the way a questionnaire is filled
out, there could be different page amounts in a section. In other words a
section could from 1 to 4 pages. Is there a way to not print blank pages in
publisher or to put in a page break similar to Microsoft word?
Thanks,
Dave

[Bob Buckland ?:-)]

Hi Dave,

It depends on the version of Publisher on
some of the capabilities, how you're bringing
over the data from Excel as to what your options
are.

In Publisher 2002, for example, Insert=>Section
will let you choose to create a new 'section'
starting with a chosen page, but not break
the text to a new page.

If you use File=>Import Word document Publisher
2002 treats Word Insert=>Breaks for sections
as follows:

Regular Page, Odd or Even Page and Next Page breaks
are all treated the same and will cause a text
box that is flowing to multiple pages to jump
the flow to a new page at that point.

Text Wrapping break will add a line break.

Continuous break will add an empty paragraph.

Working in Publisher you can use
Ctrl+Enter to force a page break in the
text that flows onto multiple pages through
Text Boxes/Frames.

For Excel worksheets, if you use File=>Open
in Publisher you may run into the 128 row
limit for a Table in Publisher, but you can
draw a text box in Publisher then copy the
spread sheet from Excel and paste it into
the Publisher 2002 Text Box and let it 'grow'
the pages. If you do that then the columns
will be separated by tabs and you can use
Ctrl+Enter to insert manual page breaks
within that flow.

You can also open an Excel sheet in Word,
insert the breaks there to match your needs
and/or to be sure there aren't over 128 rows
without a Table=>Split Table inserted :).
When you save that file from Word as a .DOC
and then use File=>Import Word File in
Publisher into a Text box it will flow the
data, create the necessary added pages and
retain the 'table column' appearance of
an Excel/Word table.

Publisher 2002 doesn't, unfortunately,
recognize Excel's Insert=>Page Breaks
as splitting the Excel sheet into 128
row chunks when using File=>OPen in Publisher.

=============
<<"Dave Melosi" <dbme...@charter.net> wrote in message news:tsmspdj...@corp.supernews.com...

--
Hope that helps,

Bob Buckland ?:-) MS Office Products family MVP
http://forums.compuserve.com/gvforums/default.asp?SRV=MSOfficeForum
*Courtesy is not expensive and can pay big dividends*