I simply want to merge down and not across . . .

[Denise]

actually, if anyone knows how i would like the name in the
first label and the title in the label next to it. If I
can't get that though, I would just like to merge down and
not across. Any suggestions before I pull my hair out?

Thank you!!!!!

 

[Doug Robbins - Word MVP]

Hi Denise,

To get the name in one "label" and the title in the one next to it, use a
"catalog" or "directory" type mailmerge with the main document containing
nothing but a one row tabel with two cells in it of the required dimensions
with the relevant mergefield in each cell.

Or, here's a macro that will 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

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Bob S]

actually, if anyone knows how i would like the name in the
first label and the title in the label next to it.

You could try creating a label template, and then merging the adjacent
horizontal cells of the table by pairs. That would give you half as
many cells two labels wide. Then place your merge fields appropriately
within the cells and go.

If I
can't get that though, I would just like to merge down and
not across. Any suggestions before I pull my hair out?

Create a merge template, modify it to be one column wide but the same
number of total cells. Do this by selecting all the rows then doing
Table | Insert Rows until you have enough rows. Then delete the extra
columns.

Bob S