Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-09-2016, 12:29 PM
webba0264 webba0264 is offline Sequentially number 100 pages of a document Windows 8 Sequentially number 100 pages of a document Office 2007
Novice
Sequentially number 100 pages of a document
 
Join Date: Jun 2016
Posts: 9
webba0264 is on a distinguished road
Unhappy Sequentially number 100 pages of a document

Hello board,

I am working in MS-Word 2007.

I have a regular document containing an ID box in the top-left hand side. It is not located within a header or a footer (See photo below)

sis.jpg

Here is my situation: I need 100 copies of this page, and each needs a unique number. In the photo, where you see "5000," I need the next page to contain "5001" in the same place.



I tried to mailmerge (I have the data source numbered), but that just put "5000" in all 100 pages of my document.

I need page 1 to say "5000" and page 100 to say "5099".

Please help! Thank you all
Reply With Quote
  #2  
Old 06-09-2016, 03:31 PM
macropod's Avatar
macropod macropod is offline Sequentially number 100 pages of a document Windows 7 64bit Sequentially number 100 pages of a document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,365
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See, for example: https://www.msofficeforums.com/word-...html#post34477
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-10-2016, 06:55 AM
webba0264 webba0264 is offline Sequentially number 100 pages of a document Windows 8 Sequentially number 100 pages of a document Office 2007
Novice
Sequentially number 100 pages of a document
 
Join Date: Jun 2016
Posts: 9
webba0264 is on a distinguished road
Default

I have no idea what I am looking at or how to apply it. If I did, I wouldn't have needed to ask for help... can you please at least describe what is going on in the demo?

I see a word document with a Form number at the top. I don't understand how that would help a novice at all.
Reply With Quote
  #4  
Old 06-10-2016, 02:15 PM
macropod's Avatar
macropod macropod is offline Sequentially number 100 pages of a document Windows 7 64bit Sequentially number 100 pages of a document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,365
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The attachment contains a Word template with a macro that prompts you to specify a start & end number. It then generates a series of pages numbered accordingly. The numbers and other content are in the page header. Did you allow Word to run the macro (it runs automatically if you do)?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 02-15-2017, 09:47 AM
webba0264 webba0264 is offline Sequentially number 100 pages of a document Windows 8 Sequentially number 100 pages of a document Office 2007
Novice
Sequentially number 100 pages of a document
 
Join Date: Jun 2016
Posts: 9
webba0264 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
The attachment contains a Word template with a macro that prompts you to specify a start & end number. It then generates a series of pages numbered accordingly. The numbers and other content are in the page header. Did you allow Word to run the macro (it runs automatically if you do)?
Hi Macropod - I was able to open the macro, and I was able to locate the field prompts "What is the first number?" etc within the script.

My question, as I don't fully understand the mechanics here, is what is required for this code to run within my document (attached)

Thank you much- AW
Attached Files
File Type: docx _unused_Referral Sheets 3000_3099.docx (11.6 KB, 13 views)
Reply With Quote
  #6  
Old 02-15-2017, 09:50 AM
webba0264 webba0264 is offline Sequentially number 100 pages of a document Windows 8 Sequentially number 100 pages of a document Office 2007
Novice
Sequentially number 100 pages of a document
 
Join Date: Jun 2016
Posts: 9
webba0264 is on a distinguished road
Default

Is there a way to have the ## in the header update sequentially with each new page? I am trying to start at number 3000 and go through 3099.
Reply With Quote
  #7  
Old 02-15-2017, 10:21 AM
webba0264 webba0264 is offline Sequentially number 100 pages of a document Windows 8 Sequentially number 100 pages of a document Office 2007
Novice
Sequentially number 100 pages of a document
 
Join Date: Jun 2016
Posts: 9
webba0264 is on a distinguished road
Default Serially number field in subsequent pages?

Here is my situation: I need 100 copies of this page, and each needs a unique number. In the attached document, where you see "3000," I need the next page to generate "3001" in the same place (all the way to 3099).

I am still trying to figure this out.


Please help! Thank you all
Attached Files
File Type: docx _unused_Referral Sheets 3000_3099.docx (11.6 KB, 15 views)
Reply With Quote
  #8  
Old 02-15-2017, 03:37 PM
macropod's Avatar
macropod macropod is offline Sequentially number 100 pages of a document Windows 7 64bit Sequentially number 100 pages of a document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,365
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I see no indication from your attachment that you've made any attempt to implement the solution in the link I provided. Doing so would be a trivial undertaking - all you need do is put the table into the page header, split the table so the number to be updated is in a cell of it's own, then put the field code in that cell.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 02-17-2017, 10:58 AM
webba0264 webba0264 is offline Sequentially number 100 pages of a document Windows 8 Sequentially number 100 pages of a document Office 2007
Novice
Sequentially number 100 pages of a document
 
Join Date: Jun 2016
Posts: 9
webba0264 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
I see no indication from your attachment that you've made any attempt to implement the solution in the link I provided. Doing so would be a trivial undertaking - all you need do is put the table into the page header, split the table so the number to be updated is in a cell of it's own, then put the field code in that cell.
Hi Macropod - I didn't fail to implement it out of sloth... I just don't understand how to do so. I've looked at your demo .dot document dozens of times...

"Put the table into the page header..." <--- What table?
"Split the table so the number to be updated is in a cell of it's own..." <--- Again, what table?
"...put the field code in that cell." <--- Within your demo, where is the field code?

I apologize for my amateurism here and do greatly appreciate your help.
Reply With Quote
  #10  
Old 02-17-2017, 11:05 AM
webba0264 webba0264 is offline Sequentially number 100 pages of a document Windows 8 Sequentially number 100 pages of a document Office 2007
Novice
Sequentially number 100 pages of a document
 
Join Date: Jun 2016
Posts: 9
webba0264 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
I see no indication from your attachment that you've made any attempt to implement the solution in the link I provided. Doing so would be a trivial undertaking - all you need do is put the table into the page header, split the table so the number to be updated is in a cell of it's own, then put the field code in that cell.
Within the VBA script, is this correct for wanting sheets numbered 3000-3099?

Quote:
Option Explicit
Private Sub Document_New()
Call Document_Open
End Sub
Private Sub Document_Open()
Dim iStart As Long, iEnd As Long, iCount As Long
On Error GoTo Done
iStart = InputBox(3000, 3000)
iEnd = InputBox(3099, 3099, iStart)
If IsNumeric(iStart) = False Or IsNumeric(iEnd) = False Then GoTo Done
If iStart > iEnd Or iEnd = 0 Then GoTo Done
iCount = iEnd - iStart
With ActiveDocument
Application.ScreenUpdating = False
.Sections.First.Headers(wdHeaderFooterPrimary).Pag eNumbers.StartingNumber = iStart
.Range.Delete
For iCount = iStart To iEnd - 1
.Range.InsertAfter Text:=Chr(12)
Next iCount
Application.ScreenUpdating = True
End With
Done:
End Sub
Reply With Quote
  #11  
Old 02-17-2017, 02:27 PM
macropod's Avatar
macropod macropod is offline Sequentially number 100 pages of a document Windows 7 64bit Sequentially number 100 pages of a document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,365
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by webba0264 View Post
"Put the table into the page header..." <--- What table?
"Split the table so the number to be updated is in a cell of it's own..." <--- Again, what table?
This is getting ridiculous. That whole shaded box in your document is a table...
Quote:
Originally Posted by webba0264 View Post
"...put the field code in that cell." <--- Within your demo, where is the field code?
Perhaps you should read https://www.msofficeforums.com/word-...html#post34488
Quote:
Originally Posted by webba0264 View Post
Within the VBA script, is this correct for wanting sheets numbered 3000-3099?
No. Why not just leave the macro code alone???
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mailmerge



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to automatically make word document have even number of total pages? lorne17 Word 6 12-16-2014 02:48 PM
Sequentially number 100 pages of a document Advanced page numbering: section pages in header, document pages in footer Albus Word 12 12-12-2014 01:36 PM
Sequentially numbered copies of multi-page word document Mark Paterson Word VBA 3 05-16-2014 04:34 PM
Sequentially number 100 pages of a document Count Number of Pages in Document with Footnotes d4okeefe Word VBA 5 11-11-2013 11:02 AM
Sequentially number 100 pages of a document Sequentially numbering a document UniAdmin Word VBA 1 02-21-2013 07:25 PM

Other Forums: Access Forums

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