Create Object Error - Please Help

[E_DPSG]

Hi all -

I have been playing around with creating a master book for out daily reporting distributions. As several of the reports are still being reviewed prior to sending, we (the reporting team) wanted to create a master file with the different distribution lists and email bodies, etc. in one file and do a 'click button' send for each group.


Here is the delema: I have added the Reference 'Microsoft Outlook 14.0 Object Library' and am receiving the following error message upon VBA execution:

" Run-time error '429': ActiveX compnent can't create object"

Short of requesting a reinstall - which I have read has resolved this issue historically - am I missing something to this error? Another reference I need to include? I have others selected, including the ActiveX Data Objects 2.8 Library

Thanks guys.

 

[s.ridd]

Hi, if you're still struggling with this error, please post your full code and also, on the off chance the error can't be replicated the line on which you're getting this error message.

Simon