Results 1 to 4 of 4
  1. #1
    davidda is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jun 2016
    Posts
    2

    Thumbs up Sending email via Gmail without using CDO or Outlook

    Hello
    I have been using CDo for years to send email via gmail without the need for Outlook. CDO has been discontinued and although it was working on my Windows 10 machine without Outlook 2007 installed, it has suddenly stopped.
    I would like to find a way to send email from Access via Google Apps (or gmail). Fro my searching nothing seems to exist.
    Can you help?

    Here is my old CDo code that worked.

    Set cdomsg = CreateObject("CDO.message")


    With cdomsg.Configuration.Fields
    .Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 'NTLM method
    .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.gmail.com"
    .Item("http://schemas.microsoft.com/cdo/configuration/smptserverport") = 465
    .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") = "me@myemaillogin.com"
    .Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "WpasswordW"
    .Update
    End With
    With cdomsg
    .To = toaddress
    .From = "'Me' <me@myemail.com>"
    .Replyto = "'Me' <me@myemail.com>"
    .subject = subject
    .HTMLBody = emailbody
    .send
    End With
    Set cdomsg = Nothing

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I've been using CDO for years as well but it is on an ac2002 system. You believe it has something to do with ac2007? Is it throwing any sort of error?

  3. #3
    davidda is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jun 2016
    Posts
    2
    Quote Originally Posted by RuralGuy View Post
    I've been using CDO for years as well but it is on an ac2002 system. You believe it has something to do with ac2007? Is it throwing any sort of error?
    I have been using an Access 2010 system (for many years) on Windows 10 (for quite a few months) and emailing was working. At first I thought it was Google but I cannot send through other systems so I have eliminated Google as the cause (I think). An update or something must have changed as now an error appears: Run-time error '-2147220973 (80040213)': The transport failed to connect to the server. I have checked and tested the server, port and login details using another application and it works. So everything points to CDO not working. From what I have read online the only way to get CDO working is to install Outlook 2007. I don't really want to do that as it doesn't make my database very portable then.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Well it sure looks like you are correct. What a disappointment.

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

Similar Threads

  1. sending email from outlook
    By darwish in forum Programming
    Replies: 1
    Last Post: 04-16-2014, 07:49 AM
  2. Replies: 1
    Last Post: 05-05-2013, 12:13 PM
  3. sending gmail email through access
    By TheShabz in forum Programming
    Replies: 20
    Last Post: 02-19-2012, 12:24 PM
  4. sending data into an email body - outlook
    By webisti in forum Access
    Replies: 6
    Last Post: 02-15-2012, 07:05 AM
  5. Sending email via Outlook (and Exchange2003) from Access2003
    By Larry Elfenbein in forum Programming
    Replies: 0
    Last Post: 11-15-2005, 09:03 PM

Tags for this Thread

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