View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default E-Mailing Code Error

Hi Sean

Check out this
http://www.rondebruin.nl/mail/problems.htm

Maybe your Win.ini is changed ?



--

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


"Sean" wrote in message oups.com...
I have the following piece of code received from Ron deBruin which all
of a sudden is hitting debug on this line

Set OutApp = CreateObject("Outlook.Application")

I'm not sure why this is now happening, when it has worked over the
last 9 months. I'm working Office XP and Win Xp. Outlook is my default
mail application. Debug message states "Run time error '-2147467259
(80004005)': Automation error, unspecified Error"

Any help would be appreciated

Thanks