VBA in Win 2K
 

I am often unable to do things in VBA in Win 2K that work fine in Win
98se. My current problem is in using SendMail. The single line of code:

ThisWorkbook.Sendmail "
works fine in Win 98 but when I run the same code in Win 2K (SP 3) I
get a 1004 error, "Application or object defined error".

Also, none of the routing functions work in 2K but work fine in 98.

In Win 2K I am logged on as an administrator.

Other than the different versions of Windows, everything else is
basically the same on the two machines - Excel 2K (SR 3), Internet
Explorer 6.2 is the browser, Outlook Express is the only email client
and Outlook is not installed.
Has anyone else had this problem and found a solution?

Thanks,
Tony

VBA in Win 2K
 

have you tried turning on the vba recorder and then FileSend ToRecipient

then looking at the code?


" wrote:

I am often unable to do things in VBA in Win 2K that work fine in Win
98se. My current problem is in using SendMail. The single line of code:

ThisWorkbook.Sendmail "
works fine in Win 98 but when I run the same code in Win 2K (SP 3) I
get a 1004 error, "Application or object defined error".

Also, none of the routing functions work in 2K but work fine in 98.

In Win 2K I am logged on as an administrator.

Other than the different versions of Windows, everything else is
basically the same on the two machines - Excel 2K (SR 3), Internet
Explorer 6.2 is the browser, Outlook Express is the only email client
and Outlook is not installed.
Has anyone else had this problem and found a solution?

Thanks,
Tony

VBA in Win 2K
 

Thanks for the reply. Yes I did try recording it and nothing records
even though the email is sent.

gocush wrote:
have you tried turning on the vba recorder and then FileSend
ToRecipient

then looking at the code?


" wrote:

I am often unable to do things in VBA in Win 2K that work fine in
Win
98se. My current problem is in using SendMail. The single line of
code:

ThisWorkbook.Sendmail "
works fine in Win 98 but when I run the same code in Win 2K (SP 3)
I
get a 1004 error, "Application or object defined error".

Also, none of the routing functions work in 2K but work fine in 98.

In Win 2K I am logged on as an administrator.

Other than the different versions of Windows, everything else is
basically the same on the two machines - Excel 2K (SR 3), Internet
Explorer 6.2 is the browser, Outlook Express is the only email
client
and Outlook is not installed.
Has anyone else had this problem and found a solution?

Thanks,
Tony

VBA in Win 2K
 

Some additional information:
When on the Win 2K machine, clicking the Mail Recipient button on the
toolbar (or File/Send To/Mail Recipient on the menu bar) and filling in
the To: and Subject: and clicking on Send works - the mail is sent.
It's just when I try to do it in VBA that I get an error.
Thanks Tony

wrote:
I am often unable to do things in VBA in Win 2K that work fine in Win
98se. My current problem is in using SendMail. The single line of
code:

ThisWorkbook.Sendmail "
works fine in Win 98 but when I run the same code in Win 2K (SP 3) I
get a 1004 error, "Application or object defined error".

Also, none of the routing functions work in 2K but work fine in 98.

In Win 2K I am logged on as an administrator.

Other than the different versions of Windows, everything else is
basically the same on the two machines - Excel 2K (SR 3), Internet
Explorer 6.2 is the browser, Outlook Express is the only email client
and Outlook is not installed.
Has anyone else had this problem and found a solution?

Thanks,
Tony

VBA in Win 2K
 

Are you able to Record any macros?
Are you SURE you clicked on the record button?
When you push the Record Button do you see the Record Macro dialog? If not,
either you haven't pushed the record button or you have a system failure.
If it is showing, do you know how the find the recorded macro in the Visual
Basic Editor: Alt+F11
And how to find your macros in the Project Explorer?

"Just Me" wrote:

Thanks for the reply. Yes I did try recording it and nothing records
even though the email is sent.

gocush wrote:
have you tried turning on the vba recorder and then FileSend
ToRecipient

then looking at the code?


" wrote:

I am often unable to do things in VBA in Win 2K that work fine in
Win
98se. My current problem is in using SendMail. The single line of
code:

ThisWorkbook.Sendmail "
works fine in Win 98 but when I run the same code in Win 2K (SP 3)
I
get a 1004 error, "Application or object defined error".

Also, none of the routing functions work in 2K but work fine in 98.

In Win 2K I am logged on as an administrator.

Other than the different versions of Windows, everything else is
basically the same on the two machines - Excel 2K (SR 3), Internet
Explorer 6.2 is the browser, Outlook Express is the only email
client
and Outlook is not installed.
Has anyone else had this problem and found a solution?

Thanks,
Tony

VBA in Win 2K
 

I found my problem and to help anyone else who may be having the same
problem, here is the solution:
In the [Mail] section of the win.ini file the following line was
missing,
MAPIX=1
Once I added that line everything started working as it should. For
more enlightenment see the Microsoft articles 290797 and 296396.
Tony

wrote:
I am often unable to do things in VBA in Win 2K that work fine in Win
98se. My current problem is in using SendMail. The single line of
code:

ThisWorkbook.Sendmail "
works fine in Win 98 but when I run the same code in Win 2K (SP 3) I
get a 1004 error, "Application or object defined error".

Also, none of the routing functions work in 2K but work fine in 98.

In Win 2K I am logged on as an administrator.

Other than the different versions of Windows, everything else is
basically the same on the two machines - Excel 2K (SR 3), Internet
Explorer 6.2 is the browser, Outlook Express is the only email client
and Outlook is not installed.
Has anyone else had this problem and found a solution?

Thanks,
Tony

VBA in Win 2K
 

I found my problem and to help anyone else who may be having the same
problem, here is the solution:
In the [Mail] section of the win.ini file the following line was
missing,
MAPIX=1
Once I added that line everything started working as it should. For
more enlightenment see the Microsoft articles 290797 and 296396.
Tony

wrote:
I am often unable to do things in VBA in Win 2K that work fine in Win
98se. My current problem is in using SendMail. The single line of
code:

ThisWorkbook.Sendmail "
works fine in Win 98 but when I run the same code in Win 2K (SP 3) I
get a 1004 error, "Application or object defined error".

Also, none of the routing functions work in 2K but work fine in 98.

In Win 2K I am logged on as an administrator.

Other than the different versions of Windows, everything else is
basically the same on the two machines - Excel 2K (SR 3), Internet
Explorer 6.2 is the browser, Outlook Express is the only email client
and Outlook is not installed.
Has anyone else had this problem and found a solution?

Thanks,
Tony