Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-23-2017, 11:28 AM
blackystrat blackystrat is offline Repeating a label 21 times on a page Windows 7 64bit Repeating a label 21 times on a page Office 2013
Novice
Repeating a label 21 times on a page
 
Join Date: Dec 2015
Posts: 9
blackystrat is on a distinguished road
Default Repeating a label 21 times on a page

Hello

I have to merge labels on an A4 paper. 21 Labels per page.

The spreadsheet contains 175 records of respective companies. What I need is to repeat the same label for each company 21 times on a single page.



So there needs to be 175 pages x 21 labels on them

Could anyone kindly guide me on how I could achieve this

Excel Version - 2013

Many thanks
Reply With Quote
  #2  
Old 05-23-2017, 08:34 PM
gmayor's Avatar
gmayor gmayor is offline Repeating a label 21 times on a page Windows 10 Repeating a label 21 times on a page Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

When you create a label merge it adds a NEXT RECORD field to each label except the first. Remove those Next Record fields and it will merge the same information to all the labels on the page, with one page for each record. Having removed the Next Record fields, you could change the merge document type to Letters and then you won't inadvertently put them back, though it will otherwise work without.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 05-23-2017, 11:52 PM
blackystrat blackystrat is offline Repeating a label 21 times on a page Windows 7 64bit Repeating a label 21 times on a page Office 2013
Novice
Repeating a label 21 times on a page
 
Join Date: Dec 2015
Posts: 9
blackystrat is on a distinguished road
Default

Hi gmayor - thanks for your response. I tried removing <<Next Record>> but when I preview or try to Finish > Edit Individual documents, it puts them back on. I even changed the Merge Document Type to letters, but it still puts them back

Kindly advise

Thanks
Reply With Quote
  #4  
Old 05-24-2017, 12:17 AM
gmayor's Avatar
gmayor gmayor is offline Repeating a label 21 times on a page Windows 10 Repeating a label 21 times on a page Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

There is no mechanism to put the Next Record fields back if you change the merge document type to Letters. It merely becomes a letters merge containing a table. Make that change and then remove the fields from the document.

Start with a label merge, which will add the { Next } fields as the first task, then add your data fields to the first cell. Propagate the data to the remaining cells. Change the document type to Letters, then run the following macro to remove the Next fields:

Code:
Sub RemoveNextFld()
    Dim ofld As Field
    For Each ofld In ActiveDocument.Fields
        If ofld.Type = wdFieldNext Then ofld.Delete
    Next ofld
End Sub
Now you can complete the merge.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 05-24-2017, 01:07 AM
blackystrat blackystrat is offline Repeating a label 21 times on a page Windows 7 64bit Repeating a label 21 times on a page Office 2013
Novice
Repeating a label 21 times on a page
 
Join Date: Dec 2015
Posts: 9
blackystrat is on a distinguished road
Default

Thanks gmayor, I was actually replacing the NEXT RECORD with blank and maybe that's why it was putting it back. I manually removed them and now it seems to work.

However, how do I move on to the next record on the spreadsheet for the next page of merge. I need to make 175 pages each for every entry on the spreadsheet

Kindly advise

Thanks again
Reply With Quote
  #6  
Old 05-24-2017, 02:14 AM
macropod's Avatar
macropod macropod is offline Repeating a label 21 times on a page Windows 7 64bit Repeating a label 21 times on a page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Simply Finish the merge, via Finish & Merge>Edit Individual Documents. Word will generate a new, 175-page document of labels.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 05-24-2017, 02:37 AM
blackystrat blackystrat is offline Repeating a label 21 times on a page Windows 7 64bit Repeating a label 21 times on a page Office 2013
Novice
Repeating a label 21 times on a page
 
Join Date: Dec 2015
Posts: 9
blackystrat is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Simply Finish the merge, via Finish & Merge>Edit Individual Documents. Word will generate a new, 175-page document of labels.
Thank you & gmayor so much. It worked perfectly
Reply With Quote
Reply

Tags
excel 2013, labels, mailmerge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Repeating a label 21 times on a page Form creation with repeating page template? vaux_2 Word 5 07-27-2016 08:37 AM
InfoPath 2013 In a Repeating Section condition a field of a nested repeating section kirvin08 Misc 0 03-15-2016 04:52 AM
Repeating a label 21 times on a page Can Text Label & PAGE Field be combined? binar Word 1 02-11-2013 03:07 AM
Repeating a label 21 times on a page Mail Merges Shifts Labels One Label per Page Reg1987 Mail Merge 3 12-03-2011 08:24 AM
Repeating a label 21 times on a page Copying page 1 800 times echomakr Word 1 09-11-2009 08:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft