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 / July 2007

Tip: Looking for answers? Try searching our database.

Duplicate or extra labels?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ManyLabels - 13 Jul 2007 13:26 GMT
Is there any way I can create multiple copies of the same label in a mail
merge? For example: I know I will need to ship multiple boxes of stock to
some customers and would need multiple labels. I am using an Excel
spreadsheet as my datasource and it would be very time consuming to add the
duplicate rows by hand.

Thanks
Graham Mayor - 13 Jul 2007 13:58 GMT
Not easily with Word, unless you always want the same number of duplicate
labels, when all you have to do is remove a few Next record fields. For two
labels for each record, delete the Next record field from the second and
every other label after that.

If the numbers vary, then you will have to manipulate the date file to
produce the required number of extra records.

Signature

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

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

> Is there any way I can create multiple copies of the same label in a
> mail merge? For example: I know I will need to ship multiple boxes of
[quoted text clipped - 3 lines]
>
> Thanks
 
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.