Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-07-2012, 03:46 PM
RetailPoint RetailPoint is offline Sequential Print Numbering Windows 7 64bit Sequential Print Numbering Office 2010 64bit
Novice
Sequential Print Numbering
 
Join Date: May 2012
Posts: 3
RetailPoint is on a distinguished road
Default Sequential Print Numbering

Hello All,



This is my first time on this site and came across this post. This sounds like something i am trying to do but with one difference, i want to print x amount of the same document but the number should increase for each printed document. One more thing, i want the number to be displayed in 3 different locations on the document.

Any help is much appreciated
Reply With Quote
  #2  
Old 05-07-2012, 04:31 PM
macropod's Avatar
macropod macropod is offline Sequential Print Numbering Windows 7 64bit Sequential Print Numbering Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Hi RetailPoint,

As your requirement is significantly different, I've split it off into a new thread.

See attached. The document uses a custom document property named 'Counter' to store the numbers. These are displayed in the document via a DOCPROPERTY field. There is one such field in the rectangle on the first page. You can have as many of these fields as and where you need throughout the body of the document. To print the document with the incrementing numbers, press Alt-F8 and select the 'FilePrint' macro.
Attached Files
File Type: zip Certificate Demo.zip (10.4 KB, 1070 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Last edited by macropod; 11-23-2013 at 01:11 AM. Reason: Demo doc enhanced to start each print sequence at 1 more than the last sequence
Reply With Quote
  #3  
Old 05-08-2012, 03:52 PM
RetailPoint RetailPoint is offline Sequential Print Numbering Windows 7 64bit Sequential Print Numbering Office 2010 64bit
Novice
Sequential Print Numbering
 
Join Date: May 2012
Posts: 3
RetailPoint is on a distinguished road
Default

Thank you so much for this file, It seems to be working fine when i try from this document. But i am not experienced with docproperty fields, would you be able to give me some more details on this?

Thank you
Reply With Quote
  #4  
Old 05-08-2012, 03:54 PM
macropod's Avatar
macropod macropod is offline Sequential Print Numbering Windows 7 64bit Sequential Print Numbering Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Hi RetailPoint,

What aspects do you want details on?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-08-2012, 03:59 PM
RetailPoint RetailPoint is offline Sequential Print Numbering Windows 7 64bit Sequential Print Numbering Office 2010 64bit
Novice
Sequential Print Numbering
 
Join Date: May 2012
Posts: 3
RetailPoint is on a distinguished road
Default

I have a form that i created. I want to be able to print the numbers in a few different places on this form. So i wanted to know how to copy the feature you gave me on your document so i can put it on my document.

I was able to create a macro on this form that i have, that will print sequential numbers when printing, i did this a long time ago and don't remember how but now i just want that same sequential number printed in a few different places on the form.
Reply With Quote
  #6  
Old 05-08-2012, 04:13 PM
macropod's Avatar
macropod macropod is offline Sequential Print Numbering Windows 7 64bit Sequential Print Numbering Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Basically, there's just two steps:
First, create the custom document property named 'Counter' to store the numbers. You do this via File > Info > Properties > Advanced properties > Custom. You'll need to give the 'Counter' property a value, say, 0.
Second, wherever you want the count to appear, add a DOCPROPERTY field that references the 'Counter' property. You can do this via Insert|Quick Parts|Field, or you can simply press Ctrl-F9 to create a pair of field braces (ie '{}') and type 'DOCPROPERTY Counter' between them, so that you end up with '{DOCPROPERTY Counter}'. In my sample document, you'll note that the numbers always have four digits (unless you're working with larger numbers), with 0 padding. This is handled by a numeric picture switch in the DOCPROPERTY field. To do the same, you'd code your's as '{DOCPROPERTY Counter \# 0000}'. When you're done, press F9 to update the field. You can then copy & paste the field to wherever else you might want it to appear in your document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 12-23-2014, 12:51 PM
berenshoes berenshoes is offline Sequential Print Numbering Windows 7 32bit Sequential Print Numbering Office 2010 32bit
Novice
 
Join Date: Dec 2014
Posts: 4
berenshoes is on a distinguished road
Default

This works as a function but won't print sequentially, what have I missed?
Reply With Quote
  #8  
Old 12-23-2014, 01:07 PM
macropod's Avatar
macropod macropod is offline Sequential Print Numbering Windows 7 64bit Sequential Print Numbering Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Perhaps you could explain what you mean - the macro works fine when used as per the instructions.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 12-23-2014, 01:25 PM
berenshoes berenshoes is offline Sequential Print Numbering Windows 7 32bit Sequential Print Numbering Office 2010 32bit
Novice
 
Join Date: Dec 2014
Posts: 4
berenshoes is on a distinguished road
Default

Well the formula creates a number but when I go to print it keeps printing 0001 and won't increase. Do I need to create a macro? I might have missed that part.
Reply With Quote
  #10  
Old 12-23-2014, 01:36 PM
berenshoes berenshoes is offline Sequential Print Numbering Windows 7 32bit Sequential Print Numbering Office 2010 32bit
Novice
 
Join Date: Dec 2014
Posts: 4
berenshoes is on a distinguished road
Default

When I press alt F8 to run the macro counter it says:
Compile error:
Expected: identifier
Reply With Quote
  #11  
Old 12-23-2014, 03:13 PM
macropod's Avatar
macropod macropod is offline Sequential Print Numbering Windows 7 64bit Sequential Print Numbering Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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 berenshoes View Post
Well the formula creates a number but when I go to print it keeps printing 0001 and won't increase. Do I need to create a macro? I might have missed that part.
The whole process is driven by a macro. That you should be asking this suggests you haven't paid much attention to the associated discussion in the thread.
Quote:
Originally Posted by berenshoes View Post
When I press alt F8 to run the macro counter it says:
Compile error:
Expected: identifier
The document in the attachment works just fine when the instructions are followed. Likewise, if implemented the same way in your own document, it will continue to work just fine. Since I can't see what you're actually doing, I can't say where the error is. That said, I'm surprised you're getting any kind of error message given the presence of error-handling code in the macro - that suggests you've changed it somehow.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #12  
Old 12-23-2014, 05:52 PM
berenshoes berenshoes is offline Sequential Print Numbering Windows 7 32bit Sequential Print Numbering Office 2010 32bit
Novice
 
Join Date: Dec 2014
Posts: 4
berenshoes is on a distinguished road
Default

You're right I somehow changed the macro, I used your example and it worked. Thanks for posting that.
Reply With Quote
  #13  
Old 01-14-2015, 04:05 AM
shanan shanan is offline Sequential Print Numbering Windows 7 32bit Sequential Print Numbering Office 2010 32bit
Novice
 
Join Date: Jan 2015
Posts: 2
shanan is on a distinguished road
Default

Hi,

Yours attached is working fine but when i print start with 1 end with 20 so it print first print 12 and 13 and start with 1 so i can understand why not print first with 1 instead of 12
Reply With Quote
  #14  
Old 01-14-2015, 05:31 AM
macropod's Avatar
macropod macropod is offline Sequential Print Numbering Windows 7 64bit Sequential Print Numbering Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

That is most likely because your printer is processing the output in the wrong order. You can fix that by turning off background printing (see under File|Options|Advanced>Print>Print in background).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #15  
Old 01-14-2015, 09:51 AM
shanan shanan is offline Sequential Print Numbering Windows 7 32bit Sequential Print Numbering Office 2010 32bit
Novice
 
Join Date: Jan 2015
Posts: 2
shanan is on a distinguished road
Default

issue fixed, thank you so much for kind support
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sequential Print Numbering Sequential numbering across multiple docs mslearner Word 18 06-12-2019 04:00 AM
Sequential Print Numbering How do I do a Sequential Numbering? gburya Word VBA 26 07-04-2017 03:29 PM
Sequential Print Numbering Sequential Numbering jdwoods Word VBA 7 12-16-2011 05:11 AM
Sequential Print Numbering Sequential Page Numbering of Multiple Word Docs bobmard Word 8 08-24-2011 08:51 AM
Page Numbering in Workbooks & Print set up problem mdouble588 Excel 0 05-21-2006 10:29 AM

Other Forums: Access Forums

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