#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
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
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#5
|
|||
|
|||
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 |
#6
|
||||
|
||||
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] |
#7
|
|||
|
|||
Thank you & gmayor so much. It worked perfectly
|
Tags |
excel 2013, labels, mailmerge |
|
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 |