Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
notv788
 
Posts: n/a
Default Multi doc mailmerge Collate+Staple

We have 3 different sets of Word docs.

They all get personalization info and have multiple pages.

We need to merge and staple each set individually, then slip sheet a blank
sheet to complete each package.
---

We have macros for this in Access, any thoughts in how to incorporate this
with Word?
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP
 
Posts: n/a
Default Multi doc mailmerge Collate+Staple

Does the personalization info for all three documents come from the one
datasource?, or can you combine the datasources so that all three documents
can be personalized from that source?

If so, you could then combine the three mail merge main documents into one,
including a blank page either before the first page or after the last page,
or in both places if that is where you want them and then if you execute the
merge to a new document, you can run the following macro over that document
to send each set of three documents to the printer as a separate print job
so that they can be stapled by the printer:

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



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

"notv788" wrote in message
...
We have 3 different sets of Word docs.

They all get personalization info and have multiple pages.

We need to merge and staple each set individually, then slip sheet a blank
sheet to complete each package.
---

We have macros for this in Access, any thoughts in how to incorporate this
with Word?



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
notv788
 
Posts: n/a
Default Multi doc mailmerge Collate+Staple

Thank you so very much!

Once inserting the section breaks, this flew without a hitch!

---
"Doug Robbins - Word MVP" wrote:

Does the personalization info for all three documents come from the one
datasource?, or can you combine the datasources so that all three documents
can be personalized from that source?

If so, you could then combine the three mail merge main documents into one,
including a blank page either before the first page or after the last page,
or in both places if that is where you want them and then if you execute the
merge to a new document, you can run the following macro over that document
to send each set of three documents to the printer as a separate print job
so that they can be stapled by the printer:

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



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

"notv788" wrote in message
...
We have 3 different sets of Word docs.

They all get personalization info and have multiple pages.

We need to merge and staple each set individually, then slip sheet a blank
sheet to complete each package.
---

We have macros for this in Access, any thoughts in how to incorporate this
with Word?




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
multiple page merge doc with multi sections, need to staple amie Mailmerge 6 September 16th 05 05:18 AM
Why doesn't Collate work in Word 2003? eukariah Microsoft Word Help 2 August 22nd 05 05:19 PM
Trying to suppress Select Table box in Excel-Word mailmerge Denise Mailmerge 4 June 21st 05 01:08 PM
Word documents won't collate, even though collate box is checked. blnorwood Microsoft Word Help 1 March 30th 05 09:51 AM
Included Property in Word 2003 MailMerge Alessio Mailmerge 1 December 23rd 04 11:26 AM


All times are GMT +1. The time now is 04:47 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"