Mail Marge Staple & Collate?

[test123]

Doug,

I have been reading your messages concerning these issues....I sa
this

The following macro will send each newsletter to the printer as
separate
print job which should then allow the stapling to take place:

Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count Step 1
.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i
End With

My questions for you are the following:

1) What versions of MS Word can this macro be used?
2) Can this macro be used in Wordperfect? If so what versions?

Thanks again for your insight

 

[Doug Robbins - Word MVP]

It can be used with any version of Word running under Windows from Word 97
onwards. I am not sure about Word on the Macintosh.

It is not designed for use with WordPerfect.

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

 

[Brian]

Doug, I hate to bother you about this topic because it seems like you're
answering it all over the internet, but this code doesn't work for me. No
matter what it only prints the first record in my mail merge. I've tried from
Excel via DDE and Access via DDE. Any ideas?

 

[Doug Robbins - Word MVP]

I would guess that you have not executed the mail merge to a new document.
You MUST do that and then with that document as the active document, you run
the macro.

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