merging data and printing one column of labels per entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat - 23 Jan 2004 06:11 GMT

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!

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 23 Jan 2004 08:39 GMT

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

Signature

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

> 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
[quoted text clipped - 12 lines]
>
> thanks!

Reply to this Message

Peter Jamieson - 23 Jan 2004 09:08 GMT

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?

> thanks!

Reply to this Message