atw: Re: MS Word Macro question

I have two sneaky workarounds that may not be suitable, but still.

Method 1: Printer driver silly buggers

On the puter which will do the horrendous batch printing.

Make two copies of the printer driver for the printer to use.

One copy call Page 1, and set its default settings to use the tray for
letterheads.

One copy call Page 2, and set its default settings to use the tray for plain
stock.

Your macro prints P1 to Page 1, then the rest to Page 2.


Method 2: Use only plain stock

Include whatever letterhead stuff as a watermark / header / footer on all
p1s.



-----Original Message-----
From: Erica Ferrigno

Hi Austechies,

Here goes...

One of our software implementation consultants is setting up a word template
that uses Transact SQL scripts to extract relevant information from a
database for use in the template. Its actually two templates that work
together: #1 is the body of the letter and includes some scripts, then it is
merged into #2 which is the standard letter format with more scripts to
populate the name, address etc etc. Our software processes template #2 to
produce one word file for each selected addressee and automates the printing
of several hundreds of individual files in any given print job.

This is fine for one page documents going to a single tray with a single
type of paper and when the company letterhead graphic is included in the
header. The problem is that the resulting document may go over one page,
which means that the first page has to go to one printer tray to use
letterhead and the subsequent pages go to another tray to print on plain
paper, for hundreds of letters. We can get the second page to print with a
page number 2 and the first page to print (from the same tray) without a
number to allow for the letterhead, but can't work out get it to print
automatically to separate trays.

I've done this manually for a single multi-page document by recording a
macro to select printer settings for our particular printer. Can printing be
automated for multiple multi-page docs using a macro in the template where
hundreds of client sites all have different printer types and settings?
Imagine setting the software to run overnight to print 500 pages when no one
is there and it stalls because the page size is incorrect!

I had a browse through MVPS and found a couple of interesting things, but I
don't know if I'm on the right track...
http://www.word.mvps.org/faqs/macrosvba/InterceptSavePrint.htm
http://www.word.mvps.org/faqs/macrosvba/DocumentEvents.htm
http://www.word.mvps.org/faqs/macrosvba/AppClassEvents.htm

If not a macro, then what?

Thanks in advance for your ideas.

Erica Ferrigno
Technical Communicator - Communications Team

IP Software Solutions, Patent Analytics, Patent, Design & Trade Mark
Renewals Worldwide Trade Mark Searching & Watching, Domain Name Management

E-mail: eferrigno@xxxxxxxxxxxxx
http://www.cpaglobal.com/software




****************************************************************************
****
The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee; access to this email by
anyone else is unauthorised.

If you are not the intended recipient: (1) you are kindly requested to
return a copy of this message to the sender indicating that you have
received it in error, and to destroy the received copy; and (2) any
disclosure or distribution of this message, as well as any action taken or
omitted to be taken in reliance on its content, is prohibited and may be
unlawful.
****************************************************************************
****

**************************************************
To post a message to austechwriter, send the message to
austechwriter@xxxxxxxxxxxxxx

To subscribe to austechwriter, send a message to
austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject field.

To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx with
"unsubscribe" in the Subject field.

To search the austechwriter archives, go to
www.freelists.org/archives/austechwriter

To contact the list administrator, send a message to
austechwriter-admins@xxxxxxxxxxxxx
**************************************************


**************************************************
To post a message to austechwriter, send the message to 
austechwriter@xxxxxxxxxxxxxx

To subscribe to austechwriter, send a message to 
austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject field.

To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx with 
"unsubscribe" in the Subject field.

To search the austechwriter archives, go to 
www.freelists.org/archives/austechwriter

To contact the list administrator, send a message to 
austechwriter-admins@xxxxxxxxxxxxx
**************************************************

Other related posts: