If you use a catalog or directory type mailmerge to get the data into the
form of word table to which you add a row at the top into which you insert
the names of the mergefields and then run this macro with that document
open, it will sort the table so that if you then save it and use it as the
data source for your label mailmerge, the labels will be in the order that
you want:
' Macro to assign numbers to data source so that it can be sorted to cause
labels to print down columns
Dim Message, Title, Default, labelrows, labelcolumns, i As Integer, j As
Integer, k As Integer
Message = "Enter the number of labels in a row" ' Set prompt.
Title = "Labels per Row" ' Set title.
Default = "3" ' Set default.
' Display message, title, and default value.
labelcolumns = InputBox(Message, Title, Default)
Message = "Enter the number of labels in a column" ' Set prompt.
Title = "Labels per column" ' Set title.
Default = "5" ' Set default.
labelrows = InputBox(Message, Title, Default)
ActiveDocument.Tables(1).Columns.Add
BeforeColumn:=ActiveDocument.Tables(1).Columns(1)
ActiveDocument.Tables(1).Rows(1).Range.Cut
k = 1
For i = 1 To ActiveDocument.Tables(1).Rows.Count - labelcolumns
For j = 1 To labelrows
ActiveDocument.Tables(1).Cell(i, 1).Range.InsertBefore k + (j - 1) *
labelcolumns
i = i + 1
Next j
k = k + 1
i = i - 1
If k Mod labelcolumns = 1 Then k = k - labelcolumns + labelcolumns *
labelrows
Next i
ActiveDocument.Tables(1).Sort FieldNumber:="Column 1"
ActiveDocument.Tables(1).Rows(1).Select
Selection.Paste
ActiveDocument.Tables(1).Columns(1).Delete

Signature
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.
Hope this helps,
Doug Robbins - Word MVP
> to bottom in word labels? The information/data taken from excel puts it in
> alphabetical order reading left to right.
Maria74 - 09 Feb 2005 18:11 GMT
Thanks, that did the trick!
> If you use a catalog or directory type mailmerge to get the data into the
> form of word table to which you add a row at the top into which you insert
[quoted text clipped - 38 lines]
> > to bottom in word labels? The information/data taken from excel puts it in
> > alphabetical order reading left to right.
Sharona - 29 Aug 2005 21:48 GMT
I am trying to follow the directions here but I MUST be missing something. I
got into macros in excel (which is the program my data is in), I copied this
macros and pasted it in and tried to run but I keep getting syntax errors. I
have never delt directly with Macros before. HELP!!
> If you use a catalog or directory type mailmerge to get the data into the
> form of word table to which you add a row at the top into which you insert
[quoted text clipped - 38 lines]
> > to bottom in word labels? The information/data taken from excel puts it in
> > alphabetical order reading left to right.
Doug Robbins - 30 Aug 2005 05:31 GMT
The macro was written to be run on a table in a Word document. Copy and
paste the data from your Excel spreadsheet into a Word document and then run
the macro when that document is the active document.
See the article "What do I do with macros sent to me by other newsgroup
readers to help me out?"
http://www.word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm

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
>I am trying to follow the directions here but I MUST be missing something.
>I
[quoted text clipped - 52 lines]
>> > in
>> > alphabetical order reading left to right.
Sharona - 30 Aug 2005 13:57 GMT
> I am trying to follow the directions here but I MUST be missing something. I
> got into macros in excel (which is the program my data is in), I copied this
[quoted text clipped - 45 lines]
> >
> > I will give this a try. Thanks so much.