I know how to use mail merge. Using an Excel database, I want to format a
2-column directory (booklet) of names, addresses, and phone numbers with
alphabetical names down the left column and wraping to the top of the right
column. The result will be a multi-page document that will be center folded
and printed on both sides. Pages should be in correct alpha sequence and
numbered. (WORD & EXCEL 2003)

Clarification please:

If you have (say) a blank cover and 10 sheets of paper with your directory,
i.e. 40 "sides" of information, the sheet next to the cover would have

side 40 side 1 on the side next to the cover and

side 2 side 39 on the other side?

etc.

I would have a look at

http://word.mvps.org/FAQs/Formatting...etPrinting.htm

and then I'd probably give up trying to do my own macro and visit

http://www.bluesquirrel.com/products/clickbook/

and/or

http://www.fineprint.com/

rather than work it out myself.

Peter Jamieson


"Bulldog" wrote in message
...
I know how to use mail merge. Using an Excel database, I want to format a
2-column directory (booklet) of names, addresses, and phone numbers with
alphabetical names down the left column and wraping to the top of the
right
column. The result will be a multi-page document that will be center
folded
and printed on both sides. Pages should be in correct alpha sequence and
numbered. (WORD & EXCEL 2003)