Macro for Outlook spelling option

[Mandrac]

Hi everyone,

I am not pretty sure if it is the right board for my question, but I would like to try.

I am using Outlook for sending my emails. You know that there is a option that checks the spelling before sending the email.

Well my question would be is it possible to write a macro to tell outlook what type of language should be checked for spelling?

E.g. if you write an email in English you have to go to the spelling options and change manually the language there to English. Same story if you would like to write an email in Spanish.

Could anyone help me with that?

I would appreciate any help.

Thanks.

Bob

 

[Dufus]

Mandrac,

I don't know anything about macros in Outlook but, if there is an option to record a macro, I'd start there by recording the spell checking of an e-mail using Spanish and then using English.

Hope that helps,
Dufus

 

[Mandrac]

Hi Dufus,

I did some research and found out that Outlook supports Macro or better said that it can record Macros.

Since I have no clue about Macros, do you know a good tutorial on how to record Macrods and how to create an button to use the recorded macro?

Thanks.

Mandrac

 

[Dufus]

Mandrac,

No, sorry. I know very little about Outlook macros.

Dufus

 

[Mandrac]

Thanks Dufus.

I tried to record a macro in excel to check the spelling and it works. But as soon as I copied the source code to outlook it come up with an run error. I think that outlook and excel using different ascii code for the same spelling language.

Here the code that actually worked with excel ?

Sub English()
'
' English Macro
' Macro recorded 10/18/2006 by Nemati Alireza
'
' Keyboard Shortcut: Ctrl+e
'
Cells.CheckSpelling SpellLang:=1033
End Sub
Sub German()
'
' German Macro
' Macro recorded 10/18/2006 by Nemati Alireza
'
' Keyboard Shortcut: Ctrl+d
'
Cells.CheckSpelling SpellLang:=1031
End Sub


Does anyone has a clue ?

Thanks

Mandrac