Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to import my Excel Mailing list into mailing label format. | Excel Discussion (Misc queries) | |||
Formula or code for address list into mailing format? | Excel Discussion (Misc queries) | |||
Using Redemption to email cells with Ron's mailing code | Excel Programming | |||
mailing list zip code starting with a 0 does not show 0 | Excel Discussion (Misc queries) | |||
Password error when e-mailing a spreadsheet. | Excel Discussion (Misc queries) |