A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Automatic Mail-Merge Compromised by Spell Checker Dialog Box



 
 
Thread Tools Display Modes
  #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





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.