Sending mail CDO from Excel 2007 on Vista

[Michelle]

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

 

[Ron de Bruin]

Yes it is working OK in Vista with O2007
No reference needed
http://www.rondebruin.nl/cdo.htm

Is it a upgrade or a clean install

 

[Michelle]

Hello Ron, thanks for coming back to me. The laptop came with Vista on. I am
running both Office 2007 and 2003, and the code doesn't work with either. I
use both Outlook and Windows mail on the machine.

I get the error message:

Run-time error '429'
ActiveX component can't create object

And it is caused by: Set iMsg = CreateObject("CDO.Message")

Michelle

 

[Ron de Bruin]

Hi Michelle

Open the workbook
Alt F11
Tools>References

Do you see a missing reference ?

 

[Michelle]

I see many, many references that are unchecked, but I don't know which ones
would be required to use CDO. I was hoping that you might know what needs to
be ticked to make it work.

M

 

[Ron de Bruin]

If you see one that is checked and you see "missing" in the text this can be a problem

The CDO code not need a reference but if you have one checked that is not on your machine it can give problems