Excel VBA - CDO Failing

[rmscho02]

Hi All,

I've got an Excel VBA macro that successfully sends an email using CDO. I am trying to run the exact same code on another computer and I get a "Transport failed to connect to the server" error message. Does anyone know how to fix this? I confirmed that I can send an email using Outlook 2007 and am using the same account/credentials in CDO, so it's got to be the CDO stuff, right? The SMTP server I'm using is a corporate Exchange 2003 server.

Also, does anyone know what the basic configuration settings should be to use CDO?

Thanks!

 

[rmscho02]

Got it answered. McAfee by default was blocking outbound emailing from mass-mailing/worms. On one machine excel.exe was added as an exception but this wasn't the case on the new machine.