Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable spell check in outgoing email
Hi,
I'm using a Excel macro that creates an email notification to different people in an column. Then I have it send using ..Display Application.SendKeys "%s" 'This feature can't be test run. Application.Wait Time + TimeValue("00:00:01") However, the program hangs up if the spell checker gets activated due to a name. The rest of the body of the message is fine. I need to know how to set it to not perform the spell check when I send the message. -- Best Regards, Luke Moraga |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable spell check in outgoing email
I'm using Outlook, 2002
If the previous question is unclear, I'm asking for the VBA coding needed to bypass the spell checker when I send an email. -- Best Regards, Luke Moraga "Luke Moraga" wrote: Hi, I'm using a Excel macro that creates an email notification to different people in an column. Then I have it send using .Display Application.SendKeys "%s" 'This feature can't be test run. Application.Wait Time + TimeValue("00:00:01") However, the program hangs up if the spell checker gets activated due to a name. The rest of the body of the message is fine. I need to know how to set it to not perform the spell check when I send the message. -- Best Regards, Luke Moraga |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable spell check in outgoing email
did you try "olMailObject.SpellingChecked = True" ?
"Luke Moraga" wrote: I'm using Outlook, 2002 If the previous question is unclear, I'm asking for the VBA coding needed to bypass the spell checker when I send an email. -- Best Regards, Luke Moraga "Luke Moraga" wrote: Hi, I'm using a Excel macro that creates an email notification to different people in an column. Then I have it send using .Display Application.SendKeys "%s" 'This feature can't be test run. Application.Wait Time + TimeValue("00:00:01") However, the program hangs up if the spell checker gets activated due to a name. The rest of the body of the message is fine. I need to know how to set it to not perform the spell check when I send the message. -- Best Regards, Luke Moraga |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable spell check in outgoing email
You can also, in Outlook, go to Tools OptionsSpelling Tab and uncheck
"Always check spelling before sending" "Luke Moraga" wrote: I'm using Outlook, 2002 If the previous question is unclear, I'm asking for the VBA coding needed to bypass the spell checker when I send an email. -- Best Regards, Luke Moraga "Luke Moraga" wrote: Hi, I'm using a Excel macro that creates an email notification to different people in an column. Then I have it send using .Display Application.SendKeys "%s" 'This feature can't be test run. Application.Wait Time + TimeValue("00:00:01") However, the program hangs up if the spell checker gets activated due to a name. The rest of the body of the message is fine. I need to know how to set it to not perform the spell check when I send the message. -- Best Regards, Luke Moraga |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable spell check in outgoing email
Hm. Looks good, but its not working for me. Where in the coding would this
go? As for unchecking the spell check box, that won't work as this program operates from the letter screen only, and on different computers. If I set it to "uncheck" that box everytime, then if it runs on a computer where intial value of box is unchecked, it will actually check it. =( I've posted the part of my code below, if someone could say where "olMailObject.SpellingChecked = True" needs to go, would be most helpful. The main structure of the coding is based off of Ron de Bruin's site. For Each cell In Sheets("Sheet2").Range("c2:c" & WorksheetFunction.CountA(Worksheets("Sheet2").Rang e("a:a"))) If LCase(cell.Offset(0, 3).Value) = "yes" _ And LCase(cell.Offset(0, 4).Value) < "send" Then 'first check Set OutMail = OutApp.CreateItem(olMailItem) With OutMail olmailobject.spellingchecked = True '<==== Where I have it now .To = cell.Value .Subject = "CAR " & cell.Offset(0, -2).Value & " needs updated" .Body = Body message goes here .Display Application.SendKeys "%p" Application.SendKeys "h" Application.SendKeys "{ENTER}" 'Sets message priority to "high" Application.SendKeys "%s" Application.Wait Time + TimeValue("00:00:01") End With Set OutMail = Nothing cell.Offset(0, 4).Value = "send" End If -- Best Regards, Luke Moraga "JLGWhiz" wrote: did you try "olMailObject.SpellingChecked = True" ? "Luke Moraga" wrote: I'm using Outlook, 2002 If the previous question is unclear, I'm asking for the VBA coding needed to bypass the spell checker when I send an email. -- Best Regards, Luke Moraga "Luke Moraga" wrote: Hi, I'm using a Excel macro that creates an email notification to different people in an column. Then I have it send using .Display Application.SendKeys "%s" 'This feature can't be test run. Application.Wait Time + TimeValue("00:00:01") However, the program hangs up if the spell checker gets activated due to a name. The rest of the body of the message is fine. I need to know how to set it to not perform the spell check when I send the message. -- Best Regards, Luke Moraga |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spell Check | Excel Worksheet Functions | |||
disable spell check whilst automatically sending email from Excel | Excel Worksheet Functions | |||
Spell check | Excel Worksheet Functions | |||
... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
disable spell check pop-up message | Excel Programming |