If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|