+ Reply to Thread
Results 1 to 5 of 5

Disable spell check in Louts Notes when sending emails via excel

  1. #1
    Forum Contributor
    Join Date
    03-13-2008
    MS-Off Ver
    Office 365
    Posts
    134

    Disable spell check in Louts Notes when sending emails via excel

    Hi,

    I have a code to send multiple email through lotus notes using excel macro, but while sending email, lotus notes use spell check which i want to disable. Can anyone advice me how to disable spell check in louts notes.

    Thanks in advance.

    Amit.

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Disable spell check in Louts Notes when sending emails via excel

    Go to File > Perefernces > Mail > Mail, then un-check Message options > Spell-check messages before sending

    Spell-Check1.jpg Spell-Check.jpg

    if you want to turn it off from within your code try
    Please Login or Register  to view this content.
    Last edited by Syrkrasi; 10-31-2017 at 11:23 AM.

  3. #3
    Forum Contributor
    Join Date
    03-13-2008
    MS-Off Ver
    Office 365
    Posts
    134

    Re: Disable spell check in Louts Notes when sending emails via excel

    Hi Syrkrasi, thanks for ur reply, I want to do within the code and once mail is sent it should enable the spell check again so that spell check should work when i send mail without the code.

    I tried adding FIELD $AutoSpell="0"; but it is not working. Below is my complete code. Can you please help me where should i put FIELD $AutoSpell="0";

    Please Login or Register  to view this content.

  4. #4
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Disable spell check in Louts Notes when sending emails via excel

    Sorry for the delay. The code I presented above will not work if your invoking the email via the UI, so I've changed the code to the following

    Add Spellchk to the list of Dim As Object

    Please Login or Register  to view this content.
    Add the following code before: Call uidoc.SEND

    Please Login or Register  to view this content.
    Here is the completed (and tested) code
    Please Login or Register  to view this content.
    See attachment
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    03-13-2008
    MS-Off Ver
    Office 365
    Posts
    134

    Re: Disable spell check in Louts Notes when sending emails via excel

    Hi Syrkrasi, Thank you very much for solving my issue... you are awesome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Sending Emails based on Check Boxes
    By rwl123456 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2017, 02:45 PM
  2. Replies: 1
    Last Post: 10-20-2014, 11:01 AM
  3. [SOLVED] Sending Outlook emails from Excel; Limits to three emails only?
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2013, 06:53 AM
  4. Sending Multiple Emails from Excel with Lotus Notes
    By kec in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2011, 02:25 PM
  5. Sending macro emails using excel: Send emails with their passwords.
    By loveisblind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 03:16 PM
  6. disable spell check box.
    By Thumper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2008, 04:42 PM
  7. disable spell check pop-up message
    By Greg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1