Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

mail merge, multi-pages, stapled sets

793 views
Skip to first unread message

Jack Gann

unread,
Dec 2, 2002, 2:26:55 PM12/2/02
to
Please provide help with multi-page, mail/merge with
stapled sets.

Here's an example scenario:

3 Contact names
2 page form letter
Portrait staple

What I need:

Three, two-page letters, each with portrait staple.

What I am getting:

One, six page letter, with one portrait staple.

It appears Word does not know how to interpret the end of
one set, and the beginning of the next set. Please help!

Peter Jamieson

unread,
Dec 3, 2002, 2:48:22 AM12/3/02
to
As far as I'm aware there is no simple way to do what you are attempting
because Word produces its mailmerge output as a single print job. The only
things I can suggest are that you
a. have a look around all the features in yout printer driver's
configuration dialogs to see if there is anything useful in there
b. if there is a specific escape sequence or piece of PostScript that says
to your printer "staple now", you may be able to insert it, either by using
a { PRINT } field (though I am not even sure that is supported these days)
or perhaps by altering the Postscript headers that can be downloaded prior
to each print job. Not my area, I'm afraid.
c. Output to a new document (as long as the numbers are small enough, and
that probably means "not very many at all"), use a macro to split the
document into its constituents and print each one.
d. Use VBA to perform the merge one source record at a time (using the
Mailmerge.Datasource obect to step through each source record and set up the
start and finish record for the merge)

Of those, I guess I'd have a look at (a) first, then go for (d).

--
Peter Jamieson
MS Word MVP

"Jack Gann" <ja...@maxdatacorp.com> wrote in message
news:010101c29a38$c63f52c0$d3f82ecf@TK2MSFTNGXA10...

Jack Gann

unread,
Dec 3, 2002, 4:25:52 PM12/3/02
to
Thanks Peter!

Unfortunately I have reviewed all printer features, and
nothing addresses the issue.

You'd mentioned using VBA... please excuse my ignorance,
but what is VBA?

>.
>

Peter Jamieson

unread,
Dec 4, 2002, 12:44:41 AM12/4/02
to
VBA is a programming language that is "built into" Word and allows you to
automate repetitive tasks (among other things). If you have ever "recorded a
macro" in Word (97 or later), you have, in effect, used VBA because it is
the language used to write macros. In the case we're discussing, what you
probably have is a typical mailmerge scenario with
a. a data source containing a number of records
b. a mail merge main document
c. a procedure whereby someone opens the mail merge main document, and
executes the merge, at which point Word opens a print job, then generates
output for each record in the data source, then closes the print job.
d. in order to overcome the problem you have, you really need a procedure
whereby someone opens the mail merge main document, then
- executes a merge just for record 1 in the data source (Word opens the
print job, does the merge, closes the merge, your printer staples the
output)
- executes a merge just for record 2....
- etc.

Doing (d) is not too hard if you only have a very small number of records in
the data source and you aren't trying to go through this exercise every few
minutes, but for more typical record counts you really need to automate the
task

In a simple case, where one stapled document corresponds to one record in
the data source, a macro to generate each document separately could be quite
simple I think.

--
Peter Jamieson
MS Word MVP

"Jack Gann" <ja...@maxdatacorp.com> wrote in message

news:03ca01c29b12$8ee6c440$d2f82ecf@TK2MSFTNGXA09...

0 new messages