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

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