?
Solved

HELP! Need to Have Word template print to Multiple OutPut Trays (HP Printer)

Posted on 2003-03-24
10
Medium Priority
?
359 Views
Last Modified: 2008-03-17
We have a custom written program that populates a word template for invoicing.  Our invoices have multiple copies for each invoice...
We have a file room copy, a customer copy, and an accting copy (for example.)  We are using Word 2000.

We have an HP 8000 with an 8 Bin output tray attached to it.  I need to find a way to specify in the Word template that this section goes to output tray 1. Section 2 goes to output tray 2 and so on.  We have looked in newsgroups and on the internet and cant seem to find a way.

We have even written a macro to print duplicate copies to different printers, but I dont think that this will work for this particular application.  I need a way to specify a section of a document to a different tray on the same printer.

I certainly hop someone can help...Please be as specific in your answer as possible...I dont know much VB scripting or working with macro's in word.

Thanks
0
Comment
Question by:pattersonr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
10 Comments
 
LVL 44

Expert Comment

by:bruintje
ID: 8200441
Hello pattersonr,

you could try as a starter
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101

HAGD:O)Bruintje
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 8203961
Patterson: I suspect that only certain portions of your invoice print, depending on the section, but is mostly the same?

So, instead of making a multi-section document, have you considered creating a document that prints hidden text or not?

Could you tell us how the invoices differ?

I think taking this route will not only simplify your printing issue, but could also alleviate file sizes.
0
 
LVL 1

Author Comment

by:pattersonr
ID: 8204813
DreamBoat or Anyone Else:
The layout of the invoice template is as follows:
The template populates a section that is considered the Accounts Receivable Copy.  This section has all of the same product and customer information as every other section.  The only thing that seems to change is the fact that each section starts renumbering the pages & each section has the title "Accounts Receivable Copy" or "File Copy" or "Customer Copy", etc.  Essentially as far as I can tell, the exact same information repopulates 4 times within the template and each section just changes the title.  I hope this helps.  Could someone explain how I might print hidden text or not (based on the specific number copy) For ex. copy 1 is AR copy, copy 2 is Customer copy, etc.  Finally, I would still need a way to separate each copy from one another.   Thanks very much for the help so far.  
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 1

Author Comment

by:pattersonr
ID: 8204821
BRUNINTJE:
Thanks for the website..although...It seems to show me how to select different input trays through word VB.  Ex. If I wanted one page legal and one page letter.  
This however is different that what I need.  
I need to specify output locations.  I have not seen any information on specifing output locations.
Thanks for the thoughts though....
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 8204899
Yes...

I would much rather see a one-section document, which should decrease the file size of your invoices to 25% current size.
Record a macro that:
Changes the word "Accounts Receivable Copy" to "File Copy" and then prints to the particular printer/tray.
Change the word "File Copy" to "Customer Copy" and then prints to the particular printer/tray.
And so on.

If the invoices don't change in any other manner from one to the next, then there's not need to have any hidden text.

See how to record a macro in Word:
www.theofficeexperts.com/officevba.htm

I'm sorry. To do it any other way is ridiculously wasting space on your server/hard drive. I am curious, however, the application in which this "custom-written program" was written.
0
 
LVL 1

Author Comment

by:pattersonr
ID: 8205260
DREAMBOAT:

Thanks very much for you continued help.
The custom Application is actually a sales entry system.   The printing component of this program is just one of the components.  The program actually is repsponsible for order entry, reports, and printing various documents, among other things.  The programmers there are very good..(however, sometimes as with this...they are using word to accomplish things) and they dont necessarily have a word guru on site. I do think you are correct though that we are probably wasting a great deal of space.  I have two concerns...First is if we attempt to have the text controlled by a macro does this make it harder or easier in your opinion to go back and say for example (email the customer a copy of the document that has Customer copy on it.  Currently we just delete all the other pages surrounding customer copy before email it.  


I have attempted to record the Macro as show on the website that you gave me....I have recorded a macro that will erase text and then print to each location output bin.
However, when I saved and reran the macro, the text was replace and the document printed 4 copies...However, the output bin did not change.  All four documents printed to the top tray.....Additional suggestions would be wonderful
Thank you
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 8205321
Hey there.

Since you only have one page, you can include in your macro to not only change to "customer copy", print it, but save it and email it, and then proceed with any other tasks...

Any way I can see one of these docs? And, exactly how you manage to print them? That's the only way that I can be sure we're doing it right.
Also, YOU have to change the output bin via Word's print option, I believe. Please make sure you did that. Also, you don't want to ERASE text, you want to "find and replace"--under the edit menu. And, of course, you'll have to delete all but the first section of the document.

Anne@TheOfficeExperts.com

(Leave your code in it if you can.)
0
 
LVL 44

Expert Comment

by:bruintje
ID: 8205825
well another piece of code that's doing printing on 2 bins maybe it helps

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=34C6A67F.30BC%40odyssey.apana.org.au
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 10321162
PAQed - no points refunded (of 50)

modulo
Community Support Moderator
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question