#1
|
|||
|
|||
Repeating a set of numbers using Mail Merge
Hello All,
I have an excel spreadsheet with 45 rows of consecutive numbering (eg 0001 to 00045). I need to print out 16 sets of these labels. The label sheet I am using has 165 labels per sheet (11 columns & 15 rows). I can get the mail merge to print out the first 45 labels, but how do I repeat for another 15 sets? Many thanks in advance. |
#2
|
||||
|
||||
The simplest method would be to create a worksheet with the 45 records repeated 16 times and merge that sheet to labels. If required, sort the revised worksheet on the numbered column.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formatting numbers in text box using Mail Merge | Rozza | Word | 1 | 11-17-2019 09:57 AM |
Formatting numbers in a mail merge | Dibble | Mail Merge | 5 | 01-04-2016 04:17 PM |
Mail merge repeating decimals issue | jmorris33 | Mail Merge | 2 | 01-10-2015 11:54 PM |
Mail Merge Formatting Phone numbers | Marie_Melody | Mail Merge | 4 | 07-02-2014 04:22 PM |
Continuous page numbers with mail merge? | Jennifer Murphy | Mail Merge | 1 | 08-11-2011 05:27 AM |