View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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