Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-20-2019, 08:23 PM
gmayor's Avatar
gmayor gmayor is offline Having Word print sequential serial numbers in a text field Windows 10 Having Word print sequential serial numbers in a text field Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,142
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 ofgmayor has much to be proud of
Default

The following will add the data and the number with a leading zero



Code:
Sub PrintJobs()
Dim i As Long, startnum As Long, lastnum As Long
Dim orng As Range
    Set orng = ActiveDocument.SelectContentControlsByTitle("Serialnumber").Item(1).Range
    startnum = InputBox("Enter the first job number to be printed", "Print Job Number", 1)
    lastnum = InputBox("Enter the last job number to be printed", "Print Job Number", 1)
    For i = startnum To lastnum
        orng.Text = Format(Date, "mmyy") & Format(i, "00")
        ActiveDocument.PrintOut
    Next
    Set orng = Nothing
End Sub
Put the button on the QAT (Quick Access Toolbar) or on the ribbon Customize the Office Ribbon (It doesn't take rocket science)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Last edited by gmayor; 08-21-2019 at 08:19 PM.
Reply With Quote
  #2  
Old 08-21-2019, 06:23 AM
limdul9992 limdul9992 is offline Having Word print sequential serial numbers in a text field Windows 10 Having Word print sequential serial numbers in a text field Office 2010
Novice
Having Word print sequential serial numbers in a text field
 
Join Date: Jul 2019
Posts: 5
limdul9992 is on a distinguished road
Default Solved and works great

Thank you very much Gmayor. That works perfectly. Thank you very much for your help.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Having Word print sequential serial numbers in a text field Looking for help with creating sequential serial number on one page 4ener Word 9 02-24-2019 07:50 AM
Sequential numbering in Word - Unique numbers for table rows krips Word 1 03-21-2018 05:06 AM
Having Word print sequential serial numbers in a text field Creating alphanumeric incremental serial numbers srinivasaru Excel Programming 8 04-03-2017 12:53 PM
Having Word print sequential serial numbers in a text field How to have sequential numbers appear in word header woodyear99 Word 1 07-18-2016 08:28 PM
Having Word print sequential serial numbers in a text field Increase serial number for every print atomtm Word 1 06-15-2012 05:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:00 PM.


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