Mac Forum / Applications / Excel / May 2008

If I understand your wish - column by column - I don't see how it could be
done with standard equipment as a regular label document. Not because of the
software, but because of the nature of printers. Most all printers print
line-by-line, so even when printing a multicolumn document (such as a
newsletter) it prints the first line of all columns then moves on to the
second, etc. as the paper feeds through. In order for it to do what you want
it would have to print the first column of labels then shift the paper back
up to start the top of the second column. IOW, It would have to "re-feed"
the paper for each column. Conceivably it could be done with a laser printer
since they compose an entire page, but I don't know of any way to have the
data sent in that way.

If using Word the one way I know of would be to use the Catalog option
instead of Labels as the Main Document. The Main Doc would have to be
created using a Columns set-up based on the number of columns of labels on
the label sheets. It would take a bit of measurement as well as trial &
error to get it set up to print accurately onto the labels, but if it's
important to have the records printed that way it may be worth it. Once you
get it right you can use it for future merges just like any other "label"
doc. If you decide to proceed & have any questions/problems post them to the
newsgroup for Mac Word rather than here, though.

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 5/9/08 12:10 PM, in article
F12B810A-1196-4516-8480-03672F69C9B8@microsoft.com, "T"