merge results of many records on one page

[jennigp]

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.

 

[Mary Sauer]

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]

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