Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 454
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 78
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 454
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 454
Default 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

  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need to import my Excel Mailing list into mailing label format. Gord Dibben Excel Discussion (Misc queries) 0 November 5th 09 10:16 PM
Formula or code for address list into mailing format? alinne5 Excel Discussion (Misc queries) 2 February 9th 08 05:25 PM
Using Redemption to email cells with Ron's mailing code Mike K Excel Programming 2 July 5th 06 10:37 PM
mailing list zip code starting with a 0 does not show 0 JmacMSA Excel Discussion (Misc queries) 1 July 19th 05 05:27 PM
Password error when e-mailing a spreadsheet. swellett Excel Discussion (Misc queries) 4 March 8th 05 05:25 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"