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)
Peter Jamieson - 18 Apr 2006 08:30 GMT
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/BookletPrinting.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
>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
[quoted text clipped - 4 lines]
> and printed on both sides. Pages should be in correct alpha sequence and
> numbered. (WORD & EXCEL 2003)