|
- Subject: Re: Turn off Outlook spell checking of messages with vba
- Author: Graham Mayor
- Date: 14 Feb 2010
- References: 1 2
Thanks Ken - I had seen an earlier reference from you which essentially said
the same thing. In this instance the problem arises because when the message
is created from vba, part of it is selected at the time it is sent. It seems
probable that all that needs to be done is to move the selection point to
the start of the message before issuing the send command for the prompt to
go away. As there won't be any spelling errors in the message (being part of
a mail merge where that will already have been addressed) the spell check
will not prompt for corrections and without the selection being selected, it
won't attempt to spell check in two parts. :)
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
"Ken Slovak - [MVP - Outlook]" <kenslovak@mvps.org> wrote in message
news:OuMp0UNrKHA.4492@TK2MSFTNGP05.phx.gbl...
the same thing. In this instance the problem arises because when the message
is created from vba, part of it is selected at the time it is sent. It seems
probable that all that needs to be done is to move the selection point to
the start of the message before issuing the send command for the prompt to
go away. As there won't be any spelling errors in the message (being part of
a mail merge where that will already have been addressed) the spell check
will not prompt for corrections and without the selection being selected, it
won't attempt to spell check in two parts. :)
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.comGraham Mayor - Word MVP
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
"Ken Slovak - [MVP - Outlook]" <kenslovak@mvps.org> wrote in message
news:OuMp0UNrKHA.4492@TK2MSFTNGP05.phx.gbl...
> Unfortunately that's just one of a bunch of settings that are read on
> startup and then maintained in memory. So the registry settings are only
> read on startup.
>
> About the only thing I can think of would be a real hack involving Win32
> API stuff to send a WM_CLOSE message to that dialog when it opens,
> monitoring for it opening. Depending on version and whether or not
> WordMail was used there'd probably be different classes for the dialog,
> that would take some work with Spy++.
>
> --
> Ken Slovak
> [MVP - Outlook]
> http://www.slovaktech.com
> Author: Professional Programming Outlook 2007.
> Reminder Manager, Extended Reminders, Attachment Options.
> http://www.slovaktech.com/products.htm
>
>
> "Graham Mayor" <gmayor@REMOVETHISmvps.org> wrote in message
> news:OIyg8VLrKHA.3792@TK2MSFTNGP05.phx.gbl...
> startup and then maintained in memory. So the registry settings are only
> read on startup.
>
> About the only thing I can think of would be a real hack involving Win32
> API stuff to send a WM_CLOSE message to that dialog when it opens,
> monitoring for it opening. Depending on version and whether or not
> WordMail was used there'd probably be different classes for the dialog,
> that would take some work with Spy++.
>
> --
> Ken Slovak
> [MVP - Outlook]
> http://www.slovaktech.com
> Author: Professional Programming Outlook 2007.
> Reminder Manager, Extended Reminders, Attachment Options.
> http://www.slovaktech.com/products.htm
>
>
> "Graham Mayor" <gmayor@REMOVETHISmvps.org> wrote in message
> news:OIyg8VLrKHA.3792@TK2MSFTNGP05.phx.gbl...
>> In developing an application for Word which sends e-mail messages using
>> Outlook, I came across an issue that I have not been able to resolve.
>> Hopefully someone will have a plan :)
>>
>> With Outlook's options configured to spell check the message before
>> sending, each message processed creates the message 'Word finished
>> checking the selection. Do you want to continue the remainder of the
>> document' which requires user intervention. Clearly if the option is
>> switched off in Outlook, the message doesn't occur. As I have no control
>> over whether users have this option set or not, I would like to switch
>> off the spell checkling for the duration of the process and thus avoid
>> the need for user interaction.
>>
>> Solutions posted on the web all seem to revolve around setting the
>> registry entry associated with the option - along the lines of
>>
>> Dim myWS As Object
>>
>> Dim RegKey As String
>>
>> Dim Key As String
>>
>> Dim Ver As Variant
>>
>> Ver = Application.version
>>
>> Key = "HKEY_CURRENT_USER\Software\Microsoft\Office\" _
>>
>> & Ver & "\Outlook\Options\Spelling\Check"
>>
>> Set myWS = CreateObject("WScript.Shell")
>>
>> 'Read key from registry
>>
>> RegKey = myWS.RegRead(Key)
>>
>> 'Write new value
>>
>> myWS.Regwrite Key, 0
>>
>> 'send message
>>
>> 'Write back original value
>>
>> myWS.Regwrite Key, RegKey
>>
>>
>>
>> While this certainly changes the registry, it has no effect on the
>> problem unless Outlook is closed and restarted.
>>
>>
>>
>> Does anyone know of a way to suppress this message from vba that does not
>> involve restarting Outlook?
>>
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>>
>>> Outlook, I came across an issue that I have not been able to resolve.
>> Hopefully someone will have a plan :)
>>
>> With Outlook's options configured to spell check the message before
>> sending, each message processed creates the message 'Word finished
>> checking the selection. Do you want to continue the remainder of the
>> document' which requires user intervention. Clearly if the option is
>> switched off in Outlook, the message doesn't occur. As I have no control
>> over whether users have this option set or not, I would like to switch
>> off the spell checkling for the duration of the process and thus avoid
>> the need for user interaction.
>>
>> Solutions posted on the web all seem to revolve around setting the
>> registry entry associated with the option - along the lines of
>>
>> Dim myWS As Object
>>
>> Dim RegKey As String
>>
>> Dim Key As String
>>
>> Dim Ver As Variant
>>
>> Ver = Application.version
>>
>> Key = "HKEY_CURRENT_USER\Software\Microsoft\Office\" _
>>
>> & Ver & "\Outlook\Options\Spelling\Check"
>>
>> Set myWS = CreateObject("WScript.Shell")
>>
>> 'Read key from registry
>>
>> RegKey = myWS.RegRead(Key)
>>
>> 'Write new value
>>
>> myWS.Regwrite Key, 0
>>
>> 'send message
>>
>> 'Write back original value
>>
>> myWS.Regwrite Key, RegKey
>>
>>
>>
>> While this certainly changes the registry, it has no effect on the
>> problem unless Outlook is closed and restarted.
>>
>>
>>
>> Does anyone know of a way to suppress this message from vba that does not
>> involve restarting Outlook?
>>
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>>
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)
All times are in (US) Eastern Daylight Time (GMT -4:00)