Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 08-29-2024, 02:48 PM
DaniMul DaniMul is offline Word doc - Mail Merge Document returns compile error if only one record available Windows 11 Word doc - Mail Merge Document returns compile error if only one record available Office 2021
Novice
Word doc - Mail Merge Document returns compile error if only one record available
 
Join Date: Aug 2024
Location: New Zealand
Posts: 4
DaniMul is on a distinguished road
Default

I found that part of code when I searched 'runtime error 5631' and found it in another forum somewhere.

This is the error here:

Run time error 5631
Word could not merge the main document with the main data source because the data records were empty or no data records matched your query options.


I adjusted as you advised so the line reads

If Err.Number = 5631 Then Err.Clear

I have re-run the mailmerge macro but this has not fixed the above runtime error popping up.

My macro works fine if there is more than one record, my problem is only if there is just one record it breaks/errors.
For example: If we have a list of 12 records for the day but the word doc I am wanting to save refers to only 1 or 3 entries, if we go into edit recipient list and only tick the ones we need we get that run time error.

If I add a filter to the full list so it only shows the entries we need rather than unticking them it will work BUT only if there are more than 1 entry.

In the meantime I have advised my colleagues if there is one entry just save as a pdf manually.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word doc - Mail Merge Document returns compile error if only one record available supress mail merge error document vincenzo345 Mail Merge 2 10-10-2017 12:03 PM
Word doc - Mail Merge Document returns compile error if only one record available Mail Merge Next Record If rule RHensley Mail Merge 10 03-07-2017 08:05 AM
avoid duplicete record and merge the record with the existed record hemant.behere Excel 0 01-10-2012 02:53 AM
compile error in Word raco Word 0 09-28-2010 12:40 PM
Extraneous record in Word Mail Merge aldo13 Mail Merge 0 01-23-2006 01:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:04 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