Vertical Label order, any way NOT macro?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maharet - 20 Feb 2008 16:19 GMT

So i see, several times, that a macro can be created to cause your labels to
merge in columns instead of rows.

I have been using Word 2003 and Excel 2003 (with the Avery 5161 Labels) in
the Mail Merge Wizard to make labels for file folders, and am wondering if
there is any way that is NOT a macro to make the labels print in order down
and then over?

Thanks!

Reply to this Message

Doug Robbins - Word MVP - 21 Feb 2008 05:35 GMT

You can achieve this by using a Directory type mail merge main document that
you set up with two columns with space between them of one quarter of an
inch an in the first column, insert a one row, one column table with fixed
cell dimensions that are the same as those of the labels that you want to
use (1" x 4"). Then in that cell, one set of the merge fields in the
configuration that you want them. Then execute the merge to a new document.

Of course if you had your data in Access (or you move it there), it has the
ability to do this built in.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> So i see, several times, that a macro can be created to cause your labels
> to
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message