We've created an application in Excel 2000 that has as part of it's code the following:
Dim OL As Object, MailSendItem As Object
'Other code in here doing other things and then
Application.Dialogs(xlDialogSendMail).Show
In OL2002 the above works great. No errors, but some of our users are being convereted to OL2003 and they are getting errors like
"You don't have appropriate permission to perform this operation" and "Cannot start Microsoft Outlook. A program error occurred. Quit Outlook and Microsoft Windows and then start again".
I put the below code into a test application:
Dim OL As Object, MailSendItem As Object
Set OL = CreateObject("Outlook.Application")
Set MailSendItem = OL.CreateItem(olMailItem)
It works great for OL2003 but errors out when users of OL2002 use this test app.
Can anyone help me out here on how to handle this or why it is reacting differently from one user to the other?
Thanks for any help!
Dim OL As Object, MailSendItem As Object
'Other code in here doing other things and then
Application.Dialogs(xlDialogSendMail).Show
In OL2002 the above works great. No errors, but some of our users are being convereted to OL2003 and they are getting errors like
"You don't have appropriate permission to perform this operation" and "Cannot start Microsoft Outlook. A program error occurred. Quit Outlook and Microsoft Windows and then start again".
I put the below code into a test application:
Dim OL As Object, MailSendItem As Object
Set OL = CreateObject("Outlook.Application")
Set MailSendItem = OL.CreateItem(olMailItem)
It works great for OL2003 but errors out when users of OL2002 use this test app.
Can anyone help me out here on how to handle this or why it is reacting differently from one user to the other?
Thanks for any help!
