+ Reply to Thread
Results 1 to 1 of 1

Use of CDO code to send emails failing

  1. #1
    Registered User
    Join Date
    01-01-2015
    Location
    Keinton Mandeville, Somerset
    MS-Off Ver
    2007
    Posts
    11

    Use of CDO code to send emails failing

    I have written an application to be used by our Seniors Captain at the Golf Club. It allows him to email Teamsheets to select players directly from Excel using Outlook. I want to adapt the application to use other mail packages other than Outlook.
    Using code supplied from Ron de Bruin's Web site I used this test program to test out the method.


    Please Login or Register  to view this content.
    End Sub

    With Port smtpserverport set to 25, I get this error message
    Run-time error '-2147220978(8004020e)':
    The server rejected the sender address. The server response was: 550 Access denied - Invalid HELO name (see RFC2821.4.1.1.1)


    With the smtpserverport set to 465 I get
    Run-time error '-2147220978(80040213)':
    The transport failed to connect to the server

    The code above was used on a computer using Outlook.
    My Outlook application uses port 465.


    I got the same result from a laptop using Windows Live Mail.

    Can anyone tell me what is wrong?
    Dave
    Last edited by JBeaucaire; 01-29-2015 at 09:29 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with code to send automatic emails
    By hauckj14 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2015, 12:45 PM
  2. Send Emails once expiry date is reached, and generate report based on emails sent
    By demonicscorpion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 05:36 AM
  3. Any Excel code to send emails automatically
    By knighty2002uk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2014, 05:55 AM
  4. VBA code to send automatic emails via outlook based on deadline
    By Britny in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2013, 10:08 AM
  5. VB Code to send emails depending on cell value
    By yorilla in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-26-2012, 11:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1