how to disable spell checker

Status
Not open for further replies.
A

Allen_N

I have built an Excel utility that fetches e-mail addresses from a database

of users and e-mails a prepared message (from a text box in a worksheet) to

some or all of the addresses. The e-mail addresses are fetched by a query and

populate a column in a worksheet. When all are to be e-mailed, I build the

recipient list from the column cells and call ShellExecute/mailto once. When

only selected addresses are to be e-mailed, I call ShellExecute/mailto in a

loop, so that the messages can be individually customised in the Outlook

composer window.

My only problem is that, in the latter mode, the Outlook spell checker is

invoked each time a new message/recipient is created.

Is it possible to programmatically disable Outlook's spell checker (from

Excel VBA), then re-enable it when done?

Thanks!

Al
 
The setting for spell checking is in the registry. Outlook reads the setting

on startup, then caches the setting and any changes in memory while Outlook

is running. If you change the Options dialog to disable spell check on send

Outlook writes the change to the registry but still relies on the in-memory

cached setting for its operations. So any change you make needs to be when

Outlook is not running.

The registry location is at

HKCU\Software\Microsoft\Office\11.0\Outlook\Options\Spelling, in the

registry value Check (a REG_DWORD value). 1 means spell check is enabled, 0

means it's disabled.

That registry path is specific to Outlook 2003, for 2007 it would be "12.0"

instead of "11.0", etc.

"Allen_N" <AllenN> wrote in message

news:1A8FB39D-1CA1-4470-8449-41938252402C@microsoft.com...
> I have built an Excel utility that fetches e-mail addresses from a database
> of users and e-mails a prepared message (from a text box in a worksheet)
> to
> some or all of the addresses. The e-mail addresses are fetched by a query
> and
> populate a column in a worksheet. When all are to be e-mailed, I build the
> recipient list from the column cells and call ShellExecute/mailto once.
> When
> only selected addresses are to be e-mailed, I call ShellExecute/mailto in
> a
> loop, so that the messages can be individually customised in the Outlook
> composer window.

> My only problem is that, in the latter mode, the Outlook spell checker is
> invoked each time a new message/recipient is created.

> Is it possible to programmatically disable Outlook's spell checker (from
> Excel VBA), then re-enable it when done?

> Thanks!

> Al

>
 
Thanks, Ken.

I don't think I want to start programmatically altering Registry keys

especially if I'm going to share the app with other people in the company.

Is there a way to detect whether or not the spell checker process runs after

invoking Outlook from ShellExecute? If I could do that, I could use SendKeys

to dismiss the spell checker pop-up and carry on with the mailing loop.

Regards,

Al
wrote:


> The setting for spell checking is in the registry. Outlook reads the setting
> on startup, then caches the setting and any changes in memory while Outlook
> is running. If you change the Options dialog to disable spell check on send
> Outlook writes the change to the registry but still relies on the in-memory
> cached setting for its operations. So any change you make needs to be when
> Outlook is not running.

> The registry location is at
> HKCU\Software\Microsoft\Office\11.0\Outlook\Options\Spelling, in the
> registry value Check (a REG_DWORD value). 1 means spell check is enabled, 0
> means it's disabled.

> That registry path is specific to Outlook 2003, for 2007 it would be "12.0"
> instead of "11.0", etc.

> >

>

> "Allen_N" <AllenN> wrote in message
> news:1A8FB39D-1CA1-4470-8449-41938252402C@microsoft.com...
> >I have built an Excel utility that fetches e-mail addresses from a database
> > of users and e-mails a prepared message (from a text box in a worksheet)
> > to
> > some or all of the addresses. The e-mail addresses are fetched by a query
> > and
> > populate a column in a worksheet. When all are to be e-mailed, I build the
> > recipient list from the column cells and call ShellExecute/mailto once.
> > When
> > only selected addresses are to be e-mailed, I call ShellExecute/mailto in
> > a
> > loop, so that the messages can be individually customised in the Outlook
> > composer window.
> > My only problem is that, in the latter mode, the Outlook spell checker is
> > invoked each time a new message/recipient is created.
> > Is it possible to programmatically disable Outlook's spell checker (from
> > Excel VBA), then re-enable it when done?
> > Thanks!
> > Al
> >


>
 
The only way I know of to do that is to use Win32 API calls to find the

spelling window class and then send a Windows Message to that window to

close down. You'd have to use Spy++ or a similar utility to find the

spelling window class name and use that in calls to something like

FindWindow() or FindWindowEx(). Then a SendOrPost to that window with

WM_CLOSE as the message should do it.

"Allen_N" <AllenN> wrote in message

news:B665C2C0-CA88-4566-8D73-23311B1197F1@microsoft.com...
> Thanks, Ken.

> I don't think I want to start programmatically altering Registry keys > especially if I'm going to share the app with other people in the company.

> Is there a way to detect whether or not the spell checker process runs
> after
> invoking Outlook from ShellExecute? If I could do that, I could use
> SendKeys
> to dismiss the spell checker pop-up and carry on with the mailing loop.

> Regards,
> Al
 
Thanks again, Ken !
wrote:


> The only way I know of to do that is to use Win32 API calls to find the
> spelling window class and then send a Windows Message to that window to
> close down. You'd have to use Spy++ or a similar utility to find the
> spelling window class name and use that in calls to something like
> FindWindow() or FindWindowEx(). Then a SendOrPost to that window with
> WM_CLOSE as the message should do it.

> >

>

> "Allen_N" <AllenN> wrote in message
> news:B665C2C0-CA88-4566-8D73-23311B1197F1@microsoft.com...
> > Thanks, Ken.
> > I don't think I want to start programmatically altering Registry keys > > especially if I'm going to share the app with other people in the company.
> > Is there a way to detect whether or not the spell checker process runs
> > after
> > invoking Outlook from ShellExecute? If I could do that, I could use
> > SendKeys
> > to dismiss the spell checker pop-up and carry on with the mailing loop.
> > Regards,
> > Al


>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
J disable Alt+S shortcut Using Outlook 21
J Hide/disable "Groups", "Shared Calendars" Using Outlook 2
G To enable/disable Allow New Time proposals Outlook VBA and Custom Forms 1
Y Disable Microsoft Outlook Test Message Using Outlook 4
J How do you disable address search box when typing @ in body of email? Using Outlook 0
L Is there a way to completely disable the "archive" box? Using Outlook 1
M Disable Contact Card Results when using "Search People" in Outlook Ribbon Using Outlook 7
U Disable "Always ask before opening" Dialog Using Outlook 3
J How do I disable advertising in Outlook 2019? Using Outlook 15
GregS Outlook 2016 Can I disable the Outlook Outbox? Using Outlook 2
R Disable conversation thread from replying of recipients in the same subject. Please help Using Outlook 0
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
N How to disable shortcuts for Pilcrow in Outlook (Show or hide paragraph marks) Using Outlook 0
N How to disable shortcuts for Pilcrow in Outlook Using Outlook 0
M Making Subject field writable (disable Read Only) Outlook VBA and Custom Forms 2
D Disable or hide "reply" and "reply to all" and "forward" in email from access vba Outlook VBA and Custom Forms 1
P Disable Spam Notifications & Sounds Using Outlook 3
O Outlook Web Access - how to disable spam filter Using Outlook 6
Diane Poremsky Disable Protected View for Outlook Attachments Using Outlook 0
E Outlook 2010 disable date auto-complete Using Outlook 2
Diane Poremsky Disable Outlook Add-ins (Apps) Using Outlook 0
J Using VBA to disable alerts / warnings Using Outlook 2
Diane Poremsky Disable the Unsafe Hyperlink Warning when Opening Attachments Using Outlook 0
N How to disable user defined fields in BCM forms Using Outlook 2
Diane Poremsky Disable Live Preview in Outlook and Word Using Outlook 0
D Preventing users to disable an Outlook Add-in Using Outlook.com accounts in Outlook 5
F Disable "Find related messages" Using Outlook 1
davecazz Anyway to disable the peek rollovers? Using Outlook 1
L Reading Pane - COMPLETELY DISABLE? Using Outlook 10
M trying to disable junk email filter. completely. Using Outlook 4
Z OL2007 - is there a way to disable the "feature" that cripples mails that are in the "junk" folder? Using Outlook 37
B How do I REALLY disable Outlook Junk E-mail sorting in OL2010 and/or 2013? Using Outlook 1
R Outlook Cache Mode Terminalserver disable through Registry Using Outlook 1
S Cannot disable OWA light Exchange Server Administration 5
A How to disable the pop-up “Reponses to this meeting will not be tallied." Using Outlook 0
D Show this folder as an e-mail Address Book is enabled but I want to disable Using Outlook 2
Rupert Dragwater how to disable billingual dictionary in outlook 2010 Using Outlook 9
J How to disable syncing folder views/layouts Using Outlook 5
A Disable hotmail from Outlook email account Using Outlook 1
R Disable request to share a calendar Using Outlook 1
T Disable the To-Do Bar permanently Using Outlook 15
J Outlook's auto time zone update for meeting requestsHow to REMOVE or DISABLE? Using Outlook 1
D Disable Junk Email in the Registry? Using Outlook 8
A How to disable bcc option in GAL - Address Book - Exchange 2007 Exchange Server Administration 4
P disable image compression Using Outlook 5
J Disable outlook 2010 no-subject warning Using Outlook 4
E Disable outlook 2010 no-subject warning Using Outlook 9
C Disable printing Outlook VBA and Custom Forms 1
A disable a menu in active inspector Outlook VBA and Custom Forms 1
N Disable control CTRL button when dragging items/folders - Outlook Outlook VBA and Custom Forms 2

Similar threads

Back
Top