Results 1 to 4 of 4
  1. #1
    KACJR is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    13

    Google to drop support for SMTP, replacing with OAuth in February 2021

    Greetings to the well of knowledge...

    As some of you may already know, Google will be dropping support for SMTP authentication for Gmail, moving to implement OAuth across its footprint. I have several code snippets that use CDO to handle sending messages from within my VBA code. I am wondering if the experts in this group have begun looking at (or perhaps solved) the issue of supporting OAuth from within VBA. I'm looking to learn how I can support this in my apps.



    Thanks,
    Ken

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    is that OAuth1 or 2?

    the attached link is for excel, but the principle should be the same for access - looks like it requires ChilKat http licence, not sure if that costs or not
    https://www.example-code.com/excel/oauth2_using_authorization_token.asp
    https://www.example-code.com/vb/smtp_gmailOAuth2.asp

    and there is this from microsoft
    https://docs.microsoft.com/en-gb/arc...xchange-online

    but it may be you need to upgrade to a later version of Access

  3. #3
    KACJR is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    13
    It's OAuth2.
    I'm currently using Access 2016 32-bit.

  4. #4
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. INvalid dates February
    By Jen0dorf in forum Access
    Replies: 5
    Last Post: 02-24-2016, 07:42 AM
  2. Replies: 1
    Last Post: 11-25-2015, 11:04 PM
  3. month February
    By azhar2006 in forum Queries
    Replies: 7
    Last Post: 07-24-2015, 09:46 PM
  4. smtp email code
    By alyon in forum Access
    Replies: 2
    Last Post: 05-15-2012, 07:42 AM
  5. Email from Access 2003 with SMTP authentication
    By prstoessel in forum Programming
    Replies: 1
    Last Post: 12-16-2011, 12:07 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