Thread: [Solved] How to staple mail merged documents
View Single Post
 
Old 06-12-2014, 01:02 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
I suspect the error message is occurring because you're using an Excel data source and it has 'used' rows below the last data row. You could probably prevent the error by inserting:
If Trim(.DataFields("FieldName")) = "" Then Exit For
after:
.ActiveRecord = i
where 'FieldName' is the name of any field in the data source that should never be empty.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote