Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-23-2017, 11:28 AM
blackystrat blackystrat is offline Windows 7 64bit Office 2013
Novice
 
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 Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,705
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
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)
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 Windows 7 64bit Office 2013
Novice
 
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 Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,705
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
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)
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 Windows 7 64bit Office 2013
Novice
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Simply Finish the merge, via Finish & Merge>Edit Individual Documents. Word will generate a new, 175-page document of labels.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 05-24-2017, 02:37 AM
blackystrat blackystrat is offline Windows 7 64bit Office 2013
Novice
 
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
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
Can Text Label & PAGE Field be combined? binar Word 1 02-11-2013 03:07 AM
Mail Merges Shifts Labels One Label per Page Reg1987 Mail Merge 3 12-03-2011 08:24 AM
Copying page 1 800 times echomakr Word 1 09-11-2009 08:00 AM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft