VBA CDO电子邮件自动化.send冻结 [英] VBA CDO Email Automation .send freeze

问题描述

我已经尝试到处搜索有关此问题的答案，因为我不敢相信这只是发生在我身上，但似乎找不到任何东西.

I have tried search everywhere for an answer on this as I can't believe it has only happened to me but can't seem to find anything.

我有一个标准的CDO电子邮件发送功能，该功能可以正常工作，大约3个月前，它可能会在不到5分钟的时间内释放大约250封电子邮件.这是在Exchange 2003上进行的.

I have a standard CDO email send function that works fine and up to about 3 months ago could reel off sending about 250 emails in probably less than 5 minutes. This was working off exchange 2003.

然后，我们将Exchange服务器升级到2010，现在我的未更改功能(除了smtp服务器的IP地址)在.send部分暂停了大约15-30秒.我只能认为这是事物交换方面发生的变化，因为我没有进行任何更改，但是它使同一个宏最多需要2-4个小时才能立即发送所有电子邮件.

Then we upgraded our exchange server to 2010 and now my function that hasn't changed (apart from the ip address of the smtp server) pauses on the .send portion for around 15-30 seconds. I can only think this is something that has changed on the exchange end of things as I haven't changed anything but it makes the same macro take up to 2-4 hours to send all the emails now.

其他人是否经历过这种情况，或者是否知道交换时需要解决什么问题才能使我的精美报告再次快速运行?

Has anyone else experienced this or know of what needs to be fixed on exchange to allow me to make my nice reports run quickly again?

非常感谢

推荐答案

必须将Exchange 2010接收连接器配置为接收传入的SMTP电子邮件，默认情况下，它们将不会打开，否则将没有打开的邮件中继.

Exchange 2010 Receive Connectors must be configured to receive incoming SMTP email, by default they will not otherwise there would be an open mail relay.

我建议您通过打开到电子邮件服务器端口25的TELNET连接并尝试手动发送电子邮件来验证服务器是否将接受来自工作站的SMTP，例如:

I suggest you verify the server will accept incoming SMTP from the workstation by opening a TELNET connection to the email server port 25 and try to manually send an email, for example:

  C: HELO myComputerName
  S: 250 smtp.theserverside.net Hello myComputerName [...] 
  C: MAIL FROM: [e-mail]
  S: 250 smtp.TheServerSide.net <[e-mail]> is syntactically correct 
  C: RCPT TP: [e-mail]
  S: 250 <[e-mail]> verified 
  C: DATA 
  S: 354 Enter message, ending with "." on a line by itself 
  C: Date: 1 April 04 10:30:42
  C: From: [e-mail]
  C: To: [e-mail]
  C: Subject: Say Hello
  C: Hello my friend! 
  C: And good bye! 
  C: . 
  S: 250 OK ID=1B3alH-0004ue-00 
  C: QUIT 
  S: 221 smtp.TheServerSide.net closing connection

如果需要在Exchange上进行调整，请小心并进行测试.接收连接器位于Microsoft Exchange管理控制台/MS Exchange内部部署/服务器配置/集线器传输

If you need to make adjustments on Exchange be careful and test. The receive connectors are at Microsoft Exchange Management Console/MS Exchange On-Prem/Server Configuration/Hub Transport

这篇关于VBA CDO电子邮件自动化.send冻结的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！