resolved:Suppress Merge Field Calculation Errors in Word 2000

[xentaur]

Many thanks for the replies to this post. Prompted me to revisit my field codes where the error was apparently generating, despite the results being accurate anyway.

FYI, the error was generating using an{ IF a=x and b=y } type scenario. Turns out the the 'and' requirement needed to be nested in its own field. Error has ceased and document functions fine.

found this useful: kb189018

Thanks all.

xentaur.

Hi there

The following issue has me perplexed to say the least and any help would be appreciated.

Merging to New document in Word 2000 using Table in Access 2000 as Data Source - document has to be bomb-proof for end-users. Snippet of code being used in main document as follows:

Application.DisplayAlerts = wdAlertsNone
ActiveDocument.MailMerge.Destination = wdSendToNewDocument
ActiveDocument.MailMerge.Execute
ThisDocument.Saved = True
CommandBars("Menu Bar").Enabled = True
CommandBars("standard").Visible = True
CommandBars("Formatting").Visible = True
Application.CommandBars("Menu Bar").Controls("&File").Controls("Save &as...").Enabled = True
ThisDocument.Close

As you can see, document merges to new document (good ol' FormLetters) and closes itself, returning standard menubars to documents (previously removed to prevent alteration to main document - just accept that it has to be that way!)

Problem is this:

The form letters are throwing merging errors at me. I've determined that the error lies in a table which calculates dates. However, the only error that is apparent is the generation of the errors - the form letters print just fine - no errors in the date calculations or anywhere else for that matter.

I'm quite happy to release this to users except that the merging to FormLetters is also generating the Mail Merge Errors document.

How can I suppress the generation of this error document, or indeed switch off error-checking during the merge so that the Mail Merge Error document is not generated, leaving my end-user with only the FormLetters on their desktops?

Any help much appreciated - I'm balding as we speak...

Cheers

xentaur