Tables in a Mailing Label Mail Merge

K

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

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
 
G

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_labels_with_word_xp.htm ) then merge to a
new document

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top