Outlook 2002 and Office2000 OK-- Using it with Office 2003 or XP Bad

[Fiat77]

We have some Excel workbooks using VBA that are in Office 2000 and work perfectly fine with Outlook 2002. Some of our user base has migrated to XP and some to Office 2003 . Now they are getting General Mail Failure errors, irregardless of whether Outlook is version 2002 or 2003. There are no missing references anywhere.

This basically happens on this line
Application.Dialogs(xlDialogSendMail).Show

What can we do to fix the problem?

We have references to the Microsoft Forms Library, Excel, Office, Micrososft Visual Baic for Applications Extensibility, Visual Basic for Applications, and OLE Automation

Thanks

 

[Sverre]

Does the error message appear before the maildialog appear. Does the maildialog appear at all?

I think you mean that the dialog do not appear.

Not quit shure what exactly it can be, but here are some thing you may check out.

If you make insert a module in a new workbook in office 2003 placing only this code:

Sub TestDialog()
Application.Dialogs(xlDialogSerndMail).Show
End sub

Save the file.
From the Meny Tools - Macro - Macros.. select "TestDialog" and run it.

On my Office 2003 this works fine.
If this works you may look elsewhere in the code in your office 2000 files for the problem.

If this do not work it may have something with settings in your office 2003. Check settings for macro security both in Excel and Outlook, diable any antivirus software.

Is VBA properly installed with Office 2003?

You can also try to copy all of the code to a new 2003 workbook. Do not include any refrences. If the code produces errors and call for refrences You can create them. (It is possible that refrences is pointing to differnt versions of the referenced object in office 2000 and Office 2003.

Hope this can be to some help.



---------------------------
There are only 10 types of people in the world. Those who know binary numbers and those who don't