How do I mailmerge ALL addresses from Excel to Publisher?

I am publishing a 36 page address directory in landscape mode, with a text
box on each page divided into two columns. I have tried exporting my Excel
spreadsheet into this directory using mail merge and get the first address on
the first page, then the second address on the second page, etc. I want to
list 8 addresses per column (16 addresses per page). What is the code I have
to use to get the addresses to list sequentially????? When I go to print or
print preview, because it is a "brochure" I don't have the option to print
Multiple pages. Help!!!

Have you looked into using the Catalog Merge?
Help here for 2007
Create a Catalog Merge
http://office.microsoft.com/en-us/pu...921831033.aspx



--
Mary Sauer
http://msauer.mvps.org/

"Blondiegee" wrote in message
...
I am publishing a 36 page address directory in landscape mode, with a text
box on each page divided into two columns. I have tried exporting my Excel
spreadsheet into this directory using mail merge and get the first address on
the first page, then the second address on the second page, etc. I want to
list 8 addresses per column (16 addresses per page). What is the code I have
to use to get the addresses to list sequentially????? When I go to print or
print preview, because it is a "brochure" I don't have the option to print
Multiple pages. Help!!!