Sending mail CDO from Excel 2007 on Vista
 

Hello, I am trying to make Ron de Bruins code work for sending email using
CDO.

Does it work with Vista/Excel 2007?

For me it falls over on the first line:
Set iMsg = CreateObject("CDO.Message")

Perhaps there is another reference I need to add or is there another way of
doing it altogether?

Thanks

Michelle

Sending mail CDO from Excel 2007 on Vista
 

Yes it is working OK in Vista with O2007

Perhaps there is another reference I need to add
No reference needed
http://www.rondebruin.nl/cdo.htm

Is it a upgrade or a clean install




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Michelle" wrote in message ...
Hello, I am trying to make Ron de Bruins code work for sending email using
CDO.

Does it work with Vista/Excel 2007?

For me it falls over on the first line:
Set iMsg = CreateObject("CDO.Message")

Perhaps there is another reference I need to add or is there another way of
doing it altogether?

Thanks

Michelle