 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / March 2008Mail Marge Staple & Collate?
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 -- test123 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.  SignatureHope 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 > Doug, > [quoted text clipped - 18 lines] > > Thanks again for your insight! 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? 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. SignatureHope 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 > 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?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.