Results 1 to 3 of 3
  1. #1
    trevor40's Avatar
    trevor40 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    407

    trying to turn off spell check for sent emails

    I have this code

    Set myItem = myOlApp.CreateItem(olmailItem)


    Set myAttachments = myItem.Attachments
    Set lst = Me!filelist
    With myItem
    For Each vItem In lst.ItemsSelected
    If Not IsNull(vItem) Then
    ttt = lst.ItemData(vItem)
    myItem.Attachments.Add ttt
    End If
    Next
    Set lst = Nothing
    myItem.To = mail_to_list
    myItem.Subject = "Incoming Logistics Movement C/N # - " & Me.Consignment_Note_Number
    myItem.HTMLBody = "<h1>" & "<b>" & "Incoming Consignment Notification - C/N # - " & Me.Consignment_Note_Number & "</b>" & "</h1>" & "<br>" & "<br>" & _
    "Received From - " & "<b>" & Me.From_Company & "</b>" & "." & "Via - " & "<b>" & Me.Courier & "</b>" & "." & " On - " & "<b>" & Me.Date_Received & "</b>" & "." & "<br>" & "<br>" & _
    "Number of Items - " & "<b>" & Me.Number_of_Items & "</b>" & "." & " Total Weight - " & "<b>" & Me.Weight & "</b>" & " Kg." & "<br>" & "<br>" & _
    "Description - " & "<b>" & Me.Description_of_Goods & "</b>" & "." & "<br>" & "<br>" & _
    "Attention To - " & "<b>" & Me.addressed_to & "</b>" & "<br>" & "<br>" & _
    "P/O or Invoice # Reference - " & "<b>" & Me.po_ref & "</b>" & "<br>" & "<br>" & _
    "Notes - " & "<b>" & Me.comments & "</b>" & "." & "<br>" & "<br>" & _
    "Thank you." & vbCrLf & _
    "Logistics Department. " & "<br>" & _
    "<img src='c:\aaa\logo.bmp'>" & "<br>" & _
    "Any views ."

    myItem.Display

    I got this from the macro in outlook that sets these options off, how do I convert this to be used in my vba code?

    .ShowGrammaticalErrors = False
    .ShowSpellingErrors = False

    P.S.

    I've done a lot of excel code via access vba, I hope it can be done the same way?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,624
    The only Show method I see is .ShowCategoriesDialog.

    Those two line do compile and the code runs and Outlook opens with my message, however, those lines error in runtime.

    I don't see any equivalent in Access.

    My Outlook does not automatically spell check.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    trevor40's Avatar
    trevor40 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    407
    thanks, i'll bypass it for now.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Spell and grammar check
    By destroyer in forum Forms
    Replies: 1
    Last Post: 01-19-2014, 11:51 AM
  2. Replies: 1
    Last Post: 09-30-2013, 05:22 PM
  3. Spell out category code letters in a report.
    By IzzyKap in forum Reports
    Replies: 1
    Last Post: 02-26-2013, 02:12 PM
  4. Suppress spell check error message
    By sabre1 in forum Forms
    Replies: 1
    Last Post: 03-24-2011, 09:58 AM
  5. Code to spell out check amount?
    By spkoest in forum Access
    Replies: 4
    Last Post: 06-16-2009, 07:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums