merge results of many records on one page

I want to merge many records as consecutive lines on a page as opposed to
each page representing a single record. Thus turning Publisher into a report
writing tool.

I have no difficulty merging labels and standard type letters etc using mail
merge from Access or Excel as the data source.

Setup your page the same way you would labels. If you want 30 records per page with a
..5 margin all around, divide 10 inches by 30, setup your custom page, 7.5 x 0.34.
With a text box this narrow you will have to change the font size and set the text
box top and bottom margin to zero.
Do some experimenting.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"jennigp" wrote in message
...
I want to merge many records as consecutive lines on a page as opposed to
each page representing a single record. Thus turning Publisher into a report
writing tool.

I have no difficulty merging labels and standard type letters etc using mail
merge from Access or Excel as the data source.

After thinking about this and how convoluted it is, why not make a report in Access
or Excel?

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"Mary Sauer" wrote in message
...
Setup your page the same way you would labels. If you want 30 records per page with
a .5 margin all around, divide 10 inches by 30, setup your custom page, 7.5 x 0.34.
With a text box this narrow you will have to change the font size and set the text
box top and bottom margin to zero.
Do some experimenting.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"jennigp" wrote in message
...
I want to merge many records as consecutive lines on a page as opposed to
each page representing a single record. Thus turning Publisher into a report
writing tool.

I have no difficulty merging labels and standard type letters etc using mail
merge from Access or Excel as the data source.