View Single Post
  #1  
Old April 25th, 2004, 04:12 AM
Leigh Webber
external usenet poster
 
Posts: n/a
Default Automatic Mail-Merge Compromised by Spell Checker Dialog Box

Try this:

ActiveDocument.Range.NoProofing = True


"Steve Le Monnier" wrote in message
...
I'm using Word2003 and VBA6 to automate the production of Mail-Merge
documents. To avoid performance problems my VBA code is running the
Mail-Merge in blocks of 200 and prior to executing the merge I deactivate
the following spell checking options:

With oMSWord
ActiveDocument.ShowSpellingErrors = False
ActiveDocument.ShowGrammaticalErrors = False
.Options.CheckSpellingAsYouType = False
.Options.CheckGrammarAsYouType = False
.Options.CheckGrammarWithSpelling = False
End With

Regardless of me doing this when word merges into a new document I'm

getting
a dialog box telling me that "There are too many spelling or grammatical
errors", this happens several time and completely wipes out my VBA code
which is unable to control the document once this message is displayed.

I've requested all spell checking activities be suspended. Why is it doing
this other than to p**s me off!
Any help gratefully received.

Steve Le Monnier