Results 1 to 7 of 7
  1. #1
    kdbailey is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2012
    Posts
    228

    Sending an Email using Chrome from Access


    I am having issues with sending an email through chrome. I receive an error with ".Send" displaying: "The 'SendUsing' configuration value is invalid."

    Do I need to have a specific reference that needs to be added? It does not seem that CDO is an object in my library.

    If it helps, my work domain is "@brp.com" and not "@gmail.com"... not sure if that makes a difference with the /sendusing configuration.

    Current code:

    Code:
    Function sendemail()
    
    Set cdomsg = CreateObject("CDO.message")
    With cdomsg.Configuration.Fields
        .Item("http://schemas.microsoft.com/cdo/connection/sendusing") = 2 'NTLM method
        .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.gmail.com"
        .Item("http://schemas.microsoft.com/cdo/configuration/smptserverport") = 587
        .Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
        .Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = True
        .Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60
        .Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "xx@xx.com"
        .Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "xx"
        .Update
    End With
    ' build email parts
    
    
    With cdomsg
        .To = "xx@xx.com"
        .From = "xx@xx.com"
        .Subject = "subject"
        .TextBody = "read"
        .Send
    End With
    
    
    Set cdomsg = Nothing
    
    
    End Function

  2. #2
    kdbailey is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2012
    Posts
    228
    Update:
    I found and included reference "Microsoft CDO for Windows 2000 Library". I now have all options in my library, but still receive the same error.

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Maybe you can declare cdomsg
    Dim cdomsg as Object

    No need for special references in Access with late binding code.

  4. #4
    kdbailey is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2012
    Posts
    228
    Quote Originally Posted by ItsMe View Post
    Maybe you can declare cdomsg
    Dim cdomsg as Object

    No need for special references in Access with late binding code.
    Same result, it won't send because the /sendusing value is incorrect. I updated my initial issue to include that my domain is not "@gmail.com". I am unsure if this makes any sort of difference or not with /sendusing, /smptserverport, /smptserver fields.

  5. #5
    kdbailey is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2012
    Posts
    228
    I tried creating a regular @gmail account to test and received same error.

  6. #6
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Hmm

    Here is an example using the same/similar schema(s)
    https://www.accessforums.net/program...tml#post223496

    Pretty sure that block is tested.

  7. #7
    kdbailey is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2012
    Posts
    228
    Absolute "Doh!" moment...

    ".../connection/sendusing" vs ".../configuration/sendusing"

    Issue solved.

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

Similar Threads

  1. sending email through Access
    By crowegreg in forum Import/Export Data
    Replies: 4
    Last Post: 04-15-2012, 03:49 PM
  2. Access sending email attachments
    By wee irish in forum Access
    Replies: 1
    Last Post: 03-06-2012, 06:11 PM
  3. sending gmail email through access
    By TheShabz in forum Programming
    Replies: 20
    Last Post: 02-19-2012, 12:24 PM
  4. Sending Report from Access as attachment in Email
    By taimysho0 in forum Programming
    Replies: 16
    Last Post: 02-09-2012, 12:07 PM
  5. SENDING EMAIL MESSAGES DIRECTLY FROM ACCESS
    By Frenchos in forum Access
    Replies: 0
    Last Post: 07-20-2007, 12:51 AM

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