Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 06-12-2014, 01:02 AM
macropod's Avatar
macropod macropod is online now How to staple mail merged documents Windows 7 32bit How to staple mail merged documents Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,520
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]
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to staple mail merged documents Align Mail Merged Numbers to the Decimal Point HangMan Mail Merge 1 12-11-2013 02:32 PM
Insert Text between Mail Merged Items kawirider88 Mail Merge 1 09-29-2013 06:55 PM
saving a mail merged document after the user edits it. kosh2 Mail Merge 0 08-05-2011 03:35 AM
How to staple mail merged documents Overlapping text once mail merged Spartan300 Mail Merge 6 10-13-2010 06:14 PM
How to staple mail merged documents No toggle b/w 2 accounts; mail merged in 1 inbox Windwardman Outlook 1 06-09-2010 09:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft