+ Reply to Thread
Results 1 to 3 of 3

Distributing emails with CDO, server issues on longer distributions.

  1. #1
    Registered User
    Join Date
    02-19-2019
    Location
    Finland
    MS-Off Ver
    2010/2016
    Posts
    3

    Post Distributing emails with CDO, server issues on longer distributions.

    Hello,
    I made a report distribution tool by using excel. The code was generating some reports and sent them by outlook, but I've decided to switch to CDO even if the code was really reliable. CDO gives me the opportunity to use the tool on a virtual machine where the antivirus is not recognized by the system, and outlook would prompt each time the request to give permission to other applications to send emails.
    CDO is working well most of the times, but on long distributions at some point I receive errors like: Transport has lost the connection to the server, or Transport is unable to connect to the server. I don't understand why this is happening. I'm creating the object at each iteration of the loop, so the configuration should be refreshed each time, no?
    How to avoid this kind of errors?
    Code to follow...

  2. #2
    Registered User
    Join Date
    02-19-2019
    Location
    Finland
    MS-Off Ver
    2010/2016
    Posts
    3

    Re: Distributing emails with CDO, server issues on longer distributions.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-19-2019
    Location
    Finland
    MS-Off Ver
    2010/2016
    Posts
    3

    Re: Distributing emails with CDO, server issues on longer distributions.

    I had to edit a bit the code since this forum was detecting some HTML inside it. "local" is supposed to be with a < before the word local and > after.

+ 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. Forum Issues and Feedback - New Server
    By Pod25 in forum The Water Cooler
    Replies: 149
    Last Post: 03-24-2017, 08:34 AM
  2. Save and rename emails to a folder on the server
    By nathandavies9 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 02-21-2017, 01:39 PM
  3. Sending Emails via Excel VBA using GMAIL SMTP Server - ERROR MESSAGE HELP!!!
    By beasley101 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2015, 09:47 AM
  4. Save Emails on a Server Using a VBA
    By nathandavies in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 11-13-2014, 12:32 PM
  5. saveas offline server issues
    By sp4rky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2009, 03:08 AM

Tags for this Thread

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