Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Staple Problem

Status
Not open for further replies.

Media01

Programmer
Dec 8, 2006
1
GB
I have a Xerox DC250 with a professional finisher installed.
I have a word document which i am merging names, address, etc from a database.

Each person has 4 pages that are personalised and when i merge to the printer i want it to staple the 4 pages togther. At the moment is staples everyones togther.

Does anyone know of a way to do this. I know HP have print commands?

Thanks in advance.



 
Hi, I had the same question a few weeks back, below is the resolution:

Here is a general approches.

1. Use the View Merged Data toggle to DISPLAY the data in each MM Field.

2. I simple macro recorded printing & advancing the record and added a for...next loop

CODE
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 11/27/2006 by SkipVought
'
For i = 1 To ActiveDocument.MailMerge.DataSource.RecordCount
ActiveDocument.PrintOut
ActiveDocument.MailMerge.DataSource.ActiveRecord = wdNextRecord
Next
End Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top