Using CDO to email from excel 2010

[azureriders]

I have a spread sheet that emails a standard form letter to everyone in a list of names and email addresses. It works GREAT on my machine running in excel 2007. I put this together for a friend and he is using 2010. He keeps getting "the transport feild failed to connect to the server". The original author of this code had a note that might happen and suggested to change the SMTP port from 25 to 465. I tried that but it made no difference, on either machine. Mine still works great, his still same error message.

Could someone please help with this. Code is below. The "Next_Customer" sub is the parrent and runs the "CDO_Send_Mail" via a loop.

I can also upload the file if that will help.

Thanks in advance.

Please Login or Register  to view this content.

[Leith Ross]

Hello azureriders,

Sometimes firewalls, proxy servers, and anti-virus software can cause problems with CDO connections. Have your friend turn these off, if present, and try it again.

[azureriders]

Thanks Leith,

I am going to be working with this set up a lot in the near future and I will keep this in mind. For this particular instance, it seems there was no problem to begin with as it all of a sudden started working for my friend. I figure he had a password or email entered incorrectly the first time.

Thanks for the help.

[winettou]

Hello! Im trying to make CDO script working under mien excel 2010, unfortunelty it give me error Run time error 429, in " Set iMsg = CreateObject("CDO.Message")" same with u script! U wrote its working under 2010, so maybe u can tell me what im missing in mine excel 2010? Ty for help

[arlu1201]

winettou,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.