ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   E-Mailing Code Error (https://www.excelbanter.com/excel-programming/384904-e-mailing-code-error.html)

Sean

E-Mailing Code Error
 
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

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

"Sean" wrote:

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



Ron de Bruin

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


Sean

E-Mailing Code Error
 
On Mar 9, 3:31 pm, "Ron de Bruin" wrote:
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



"Sean" wrote in ooglegroups.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- Hide quoted text -


- 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

E-Mailing Code Error
 
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 Bruin
http://www.rondebruin.nl/tips.htm


"Sean" wrote in message ups.com...
On Mar 9, 3:31 pm, "Ron de Bruin" wrote:
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



"Sean" wrote in ooglegroups.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- Hide quoted text -


- 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


Sean

E-Mailing Code Error
 
On Mar 9, 6:07 pm, "Ron de Bruin" wrote:
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



"Sean" wrote in oglegroups.com...
On Mar 9, 3:31 pm, "Ron de Bruin" wrote:
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


"Sean" wrote in ooglegroups.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- Hide quoted text -


- 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- Hide quoted text -


- 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

E-Mailing Code Error
 
You can remove the one that is not in the Mail section

--

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


"Sean" wrote in message oups.com...
On Mar 9, 6:07 pm, "Ron de Bruin" wrote:
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



"Sean" wrote in oglegroups.com...
On Mar 9, 3:31 pm, "Ron de Bruin" wrote:
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


"Sean" wrote in ooglegroups.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- Hide quoted text -


- 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- Hide quoted text -


- 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



All times are GMT +1. The time now is 09:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com