E-Mailing Code Error

[Sean]

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

 

[Madhan]

Hi, in my opinion, you have to set reference to MS Outlook component via
Tools -> Reference. This should solve your problem.

 

[Ron de Bruin]

Hi Sean

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

Maybe your Win.ini is changed ?

 

[Sean]

Hi Sean

Check out thishttp://www.rondebruin.nl/mail/problems.htm

Maybe your Win.ini is changed ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm









- Show quoted text -

Thanks Ron, I've just got it to work. On the WIN.ini file "MAPIX=1"
was in the file but not below "MAIL" - I assume that it must be placed
just below it, as per your web info, although I don't know why the
WINI.ini file would change in the first instance

Thanks again

 

[Ron de Bruin]

It is very strange Sean.

I see this problem a few years now in the newsgroup.(never have the problem myself)
Maybe it is update that change the Win.ini file

Have you more then one Office version on your machine ?
Installed new programs lately ?

I really like to know why the ini file changed.

Excel 2003 and up not use the win.ini file anymore

 

[Sean]

It is very strange Sean.

I see this problem a few years now in the newsgroup.(never have the problem myself)
Maybe it is update that change the Win.ini file

Have you more then one Office version on your machine ?
Installed new programs lately ?

I really like to know why the ini file changed.

Excel 2003 and up not use the win.ini file anymore

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm







- Show quoted text -

No just the single Office 2002 XP version. Not aware of any new
software installed (there shouldn't have been)
Is it correct to say that unless the MAPIX=1 is not just below the
MAIL, there will be problems? As I've said MAPIX=1 was in the WIN.ini
file, just not below it. I didn't remove the first instance of
MAPIX=1, so I have 2 instances of it now, should I?

Thanks

 

[Ron de Bruin]

You can remove the one that is not in the Mail section