[KT]

I want to know how to include a two-column table per mailing label in my
address label mail merge. I am trying to replicate a patient chart label on
a medical record for a training class I am offering. When I tried to do
this, I get one page of labels (30 total) with the first row of data on my
Excel spreadsheet. The second page of labels is the second row of data on my
spreadsheet. I want one page of labels (30 labels total) with my 30 rows of
data from the spreadsheet.

[Doug Robbins - Word MVP]

You need to replicate the setup in the first label in the mail merge main
document to each of the other labels on the sheet and before the first merge
field in each of those other labels, you need to insert a Next Record
field.

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

"KT" wrote in message
...
I want to know how to include a two-column table per mailing label in my
address label mail merge. I am trying to replicate a patient chart label
on
a medical record for a training class I am offering. When I tried to do
this, I get one page of labels (30 total) with the first row of data on my
Excel spreadsheet. The second page of labels is the second row of data on
my
spreadsheet. I want one page of labels (30 labels total) with my 30 rows
of
data from the spreadsheet.

[Graham Mayor]

Further to Doug's comments, you are not going to achieve this with columns,
or a label merge. You need to create a new table document from the label
wizard, which will give you the correct label sizes, then split each cell
vertically to give you your columns. Create your merge entry in the first
split label and add a Next Record field to the start of the left cell. Then
copy and paste the split cells to the rest of the split cells on the page.
Finally remove the Next Record field from the first cell. The procedure is
similar to that shown at http://www.gmayor.com/mail_merge_graphics.htm

Set the document type as Letter and add your data source
(http://www.gmayor.com/mail_merge_lab...th_word_xp.htm ) then merge to a
new document

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Doug Robbins - Word MVP wrote:
You need to replicate the setup in the first label in the mail merge
main document to each of the other labels on the sheet and before the
first merge field in each of those other labels, you need to insert a
Next Record field.


"KT" wrote in message
...
I want to know how to include a two-column table per mailing label
in my address label mail merge. I am trying to replicate a patient
chart label on
a medical record for a training class I am offering. When I tried
to do this, I get one page of labels (30 total) with the first row
of data on my Excel spreadsheet. The second page of labels is the
second row of data on my
spreadsheet. I want one page of labels (30 labels total) with my 30
rows of
data from the spreadsheet.