Mail merge and printing

[Corky]

Frequently we have to run labels which can run into the many hundreds of
labels. When I try to print multiple copies of these batches, the printer
will not collate them even though we have collation set as the default on
both the printer object and the print job. I can collate from file or any
other type of .doc or.xls, but not from the mail merge function.

Any suggestions?

 

[Doug Robbins - Word MVP]

Execute the merge to a new document and then print as many copies of that as
you require with the appropriate collation settings.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Corky]

I appreciate the reply.
Every time we run the batch file to generate the labels, it is merged to a
new document. When we go to print from that .doc, even setting the printer to
collate, it will not do so.

Thanx,
Corky

 

[Doug Robbins - Word MVP]

This then is nothing to do with mail merge. If by collate, you mean that
you want the document printed in order p1, p2, p3 ... then p, p2, p3 then
you could use a macro

Dim copies As Long, i As Long
copies = InputBox("Enter the number of copies required.")
For i = 1 To copies
ActiveDocument.PrintOut
Next i


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Corky]

Thanks Doug.
We'll give this a try and let you know how it works out.
Again, thanks.

Corky