Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-20-2023, 06:56 PM
Whubbard Whubbard is offline Repeating a set of numbers using Mail Merge Windows 10 Repeating a set of numbers using Mail Merge Office 2021
Novice
Repeating a set of numbers using Mail Merge
 
Join Date: May 2023
Posts: 1
Whubbard is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 05-21-2023, 04:24 AM
gmayor's Avatar
gmayor gmayor is offline Repeating a set of numbers using Mail Merge Windows 10 Repeating a set of numbers using Mail Merge Office 2019
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

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
Reply With Quote
Reply

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
Repeating a set of numbers using Mail Merge Formatting numbers in a mail merge Dibble Mail Merge 5 01-04-2016 04:17 PM
Repeating a set of numbers using Mail Merge Mail merge repeating decimals issue jmorris33 Mail Merge 2 01-10-2015 11:54 PM
Repeating a set of numbers using Mail Merge Mail Merge Formatting Phone numbers Marie_Melody Mail Merge 4 07-02-2014 04:22 PM
Repeating a set of numbers using Mail Merge Continuous page numbers with mail merge? Jennifer Murphy Mail Merge 1 08-11-2011 05:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:37 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