M
Mary Thomas
Hi, another excel dummy question I'm sure, but here goes. I recorded a macro
in excel to got to File>Send as Attachment.
The actual VB text reads:
Sub SubmittoPPI()
'
' SubmittoPPI Macro
' Macro recorded 07/20/2006 by MSMD11
'
'
Application.Dialogs(xlDialogSendMail).Show
End Sub
It works fine on my pc but when I test it on someone else's pc we get the
following error message:
Method of Dialog Class Failed.
Can anyone help me fix this error? we are using Lotus Noted not Outlook. I
don't know if that is relevant or not.
Thanks,
Mary
in excel to got to File>Send as Attachment.
The actual VB text reads:
Sub SubmittoPPI()
'
' SubmittoPPI Macro
' Macro recorded 07/20/2006 by MSMD11
'
'
Application.Dialogs(xlDialogSendMail).Show
End Sub
It works fine on my pc but when I test it on someone else's pc we get the
following error message:
Method of Dialog Class Failed.
Can anyone help me fix this error? we are using Lotus Noted not Outlook. I
don't know if that is relevant or not.
Thanks,
Mary