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 Chriss Miller 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
Joined
Dec 8, 2006
Messages
1
Location
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