Macro for Outlook spelling option

Mandrac

New Member
Joined
Sep 26, 2006
Messages
4
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
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Dufus

Board Regular
Joined
Aug 19, 2006
Messages
176
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

New Member
Joined
Sep 26, 2006
Messages
4
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

Board Regular
Joined
Aug 19, 2006
Messages
176
Mandrac,

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

Dufus
 

Mandrac

New Member
Joined
Sep 26, 2006
Messages
4
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 ? :cry:

Thanks

Mandrac
 

Forum statistics

Threads
1,136,878
Messages
5,678,297
Members
419,753
Latest member
Sallylwy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top