How do I merge label records down then across?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TheFunRev - 31 Aug 2004 07:01 GMT

I want to run a mailmerge on a 30-label per page basis, but I want the
document to merge records 1-10 in the first column, 11-20 in the second,
21-30 in the third, and so on in 10s down and across subsequent pages. All I
can get WORD to do is across the rows (1-3) then down (4-6, 7-9, etc.)
Everything else works beautifully. Help!

Reply to this Message

Doug Robbins - 01 Sep 2004 00:55 GMT

If you have Access, it can do this automatically. Otherwise, if the
datasource is table in Word, you can use the following macro:

' 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

>I want to run a mailmerge on a 30-label per page basis, but I want the
> document to merge records 1-10 in the first column, 11-20 in the second,
> 21-30 in the third, and so on in 10s down and across subsequent pages.
> All I
> can get WORD to do is across the rows (1-3) then down (4-6, 7-9, etc.)
> Everything else works beautifully. Help!

Reply to this Message

Rate this thread: