Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2007

Tip: Looking for answers? Try searching our database.

Tables in a Mailing Label Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
KT - 23 Mar 2007 19:52 GMT
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 - 24 Mar 2007 00:02 GMT
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.

Signature

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

>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
[quoted text clipped - 6 lines]
> of
> data from the spreadsheet.
Graham Mayor - 24 Mar 2007 07:49 GMT
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

Signature

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

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

> 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
[quoted text clipped - 11 lines]
>> rows of
>> data from the spreadsheet.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.