Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2004

Tip: Looking for answers? Try searching our database.

Automatic Mail-Merge Compromised by Spell Checker Dialog Box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve Le Monnier - 23 Apr 2004 15:27 GMT
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
Leigh Webber - 25 Apr 2004 04:12 GMT
Try this:

ActiveDocument.Range.NoProofing = True

> I'm using Word2003 and VBA6 to automate the production of Mail-Merge
> documents. To avoid performance problems my VBA code is running the
[quoted text clipped - 19 lines]
>
> Steve Le Monnier
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.