CDO Email - Exchange Server

[xlStar]

Previously my Excel VBA works OK sending out email until IT had switched off our POP3 and SMPT email address as one year ago we moved to Exchange Server and now uses Outlook Web Access.

My code...
oEmail.Configuration.Fields.Item("

http://schemas.microsoft.com/cdo/configuration/smtpserver")

= "smtp.mycompanyname.co.uk"

...doesn't work anymore!

Should there be similar (replacement) code for smtp.mycompanyname.co.uk?

or do I need to have a brand new codes to use Outlook Web Access via VBA?

 

[TheKentO]

I had similar problem until I found the solution on Ron Debruin's website. I would put the code here but it is not my creation and it is worth seeing some of his other code too. He is a great resource!!!!

http://www.rondebruin.nl/tips.htm