VBA in Win 2K

  • Thread starter Thread starter atlinc
  • Start date Start date
A

atlinc

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 "(e-mail address removed)"
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
 
have you tried turning on the vba recorder and then File>Send To>Recipient

then looking at the code?
 
Thanks for the reply. Yes I did try recording it and nothing records
even though the email is sent.
 
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
 
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?
 
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
 
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
 
Back
Top