Word doc - Mail Merge Document returns compile error if only one record available

Guessed · #1 08-28-2024, 03:58 PM

This compile error is misleading (and has nothing to do with the record count). The actual problem is that you have an If statement inside the For/Next loop that does not close.

Where was this line going to close with an End If?

If Err.Number = 5631 Then

DaniMul · #2 08-28-2024, 06:26 PM

Quote:

Originally Posted by Guessed

This compile error is misleading (and has nothing to do with the record count). The actual problem is that you have an If statement inside the For/Next loop that does not close.

Where was this line going to close with an End If?
If Err.Number = 5631 Then

ok I see I need an End if but where can I put it?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
supress mail merge error document	vincenzo345	Mail Merge	2	10-10-2017 12:03 PM
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