atw: MS Word Macro question

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
**************************************************

Other related posts: