merging data and printing one column of labels per entry

[Pat]

the 1/3 cut file folder labels come 30 per sheet -- every day I have to print 15 labels (three lines each) for each new account (between 20 and 25 accounts each day) -- I have set up a mail merge document to print two sets of 15 labels each -- the top 15 labels have one account, the bottom 15 labels have the next account's informatoin, et

because the labels are not always used immediately, the one label sheet has to be cut in "half" -- which means tha
sometimes the "middle" labels are ruine

fewer labels would have to be redone, and it would be easier on everyone, if we could print the file folder labels by column -- i.e., so that we get 15 labels for one account on the right and 15 on the left for the next account, etc -- does anyone know how to accomplish this

thanks!

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Pat,

Instead of using mailmerge, it might just be easier to save a blank sheet of
the labels as a template and type the details for the 2 sets of labels into
the first row of labels. Then if you run a macro containing the following
code, it will copy the information down the two columns of labels:

Dim i As Long, j As Long, myrange As Range
For j = 1 To 3 Step 2
Set myrange = ActiveDocument.Tables(1).Cell(1, j).Range
myrange.End = myrange.End - 1
For i = 3 To 29 Step 2
ActiveDocument.Tables(1).Cell(i, j).Range = myrange
Next i
Next j


--
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

 

[Peter Jamieson]

There are a few possibilities including:
a. reformat your document two use two snaking columns (Format|Columns)with
a single one-column table in each (or perhaps even a single-column table
that spans the two snaking columns.
b. use { SET } fields to save the values of the data in the record then use
REF fields, e.g. for a single simple field

row1 column1

{ SET c1 { MERGEFIELD myfield }
}{ REF c1 }

row2 column2
{ NEXT }
{ SET c2 { MERGEFIELD myfield }
}{ REF c2 }


row2 column1

{ REF c1 }

row2 column2

{ REF c2 }

etc.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

the 1/3 cut file folder labels come 30 per sheet -- every day I have to

print 15 labels (three lines each) for each new account (between 20 and 25
accounts each day) -- I have set up a mail merge document to print two sets
of 15 labels each -- the top 15 labels have one account, the bottom 15
labels have the next account's informatoin, etc

because the labels are not always used immediately, the one label sheet

has to be cut in "half" -- which means that

sometimes the "middle" labels are ruined

fewer labels would have to be redone, and it would be easier on everyone,

if we could print the file folder labels by column -- i.e., so that we get
15 labels for one account on the right and 15 on the left for the next
account, etc -- does anyone know how to accomplish this?