Results 1 to 11 of 11
  1. #1
    Danielh1000 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2020
    Posts
    10

    Port 587 CDO Email

    I can send emails using smtp.office365.com, port 25, usessl, server requires authentication, but when using the same settings and port 587 I get "transport faield to server".



    Port 25 is blocked by many ISPs, and Microsoft recommends using port 587, so would like to use a port other than 25.

    Are there required settings for Port 587, or is another port viable?

    I am using Access 2010. Windows 10 64 bit.

    Thanks

  2. #2
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,126
    I have this section of code specifically for port 587

    Code:
        If txtPort = 587 Then
            .Item("http://schemas.microsoft.com/cdo/configuration/sendtls").Value = True
        End If
    This comes from my CDO Email Tester example app http://www.mendipdatasystems.co.uk/e...ter/4594365455
    It includes a help file explaining how to manage all CDO errors I've ever come across
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  3. #3
    Danielh1000 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2020
    Posts
    10
    Sorry this didn't help...I put the code in my DB and if failed, and then I used your CDO Email Tester...I have attached a screen shot of the failed port 587 failure; the same settings with Port 25 work

    Thanks for any help
    Attached Files Attached Files

  4. #4
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,126
    It would have been much easier if you saved a screenshot of the error and attached that rather than a Word doc which I had to zoom to read it!

    Did you read the help file that came with the app?
    That message is shown if your settings are incorrect e.g. server address or port wrong. This is also shown if Use SSL setting is incorrect
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  5. #5
    Danielh1000 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2020
    Posts
    10
    Colin...Since using Port 25 works, all the server settings are correct. Port 587 with SSL results in the transport error, port 587 without SSL results in failure to authenticate

    Are you able to send using port 587? If yet, what settings work for you?
    Attached Thumbnails Attached Thumbnails Failure To Authenticate.png  

  6. #6
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,126
    The following works for me:

    Click image for larger version. 

Name:	Capture.PNG 
Views:	14 
Size:	34.1 KB 
ID:	40836

    The only change I made was the port from 25 to 587
    If those settings don't work for you, it may be that your server doesn't allow the use of port 587
    Try with a different email account
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  7. #7
    Danielh1000 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2020
    Posts
    10
    Colin....looks like its a smtp.office365,com issue...thanks for all the help

  8. #8
    Danielh1000 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2020
    Posts
    10
    Colin...I decided that trying to resolve an office365 issue might be painful, so tried smtp.gmail.com. I can't get it to work. Could you share the smtp server you used with port 587, and I could setup and account and use that server. Thanks

  9. #9
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,126
    That particular account is for BTInternet and the server is mail.btinternet.com
    However, I doubt you can use that server without having BT Broadband or if you live outside the UK

    I also use CDO with a GMail account. There are extra hurdles to jump to comply with Google's two step authentication.
    Details in the help file of my CDO Email Tester
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  10. #10
    Danielh1000 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2020
    Posts
    10
    Colin....Brilliant by you! Guess I should have read the help file about Gmail...sorry...

  11. #11
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,126
    You're welcome.
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

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

Similar Threads

  1. Receive Data from external IP on Network over Port
    By WhiteBearMike in forum Programming
    Replies: 1
    Last Post: 10-19-2018, 04:34 PM
  2. Replies: 1
    Last Post: 07-24-2015, 11:31 AM
  3. CDO test if port is open first
    By Ruegen in forum Programming
    Replies: 0
    Last Post: 09-03-2014, 09:06 PM
  4. Acquire Blue Tooth GPS data via comm port
    By Galmala in forum Import/Export Data
    Replies: 1
    Last Post: 04-18-2013, 01:49 PM
  5. Capture data from TCP port
    By todster in forum Access
    Replies: 0
    Last Post: 07-19-2011, 12:22 AM

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 - Senior Forums