Trouble with E-Mailing Spreadsheet

  • Thread starter Thread starter Ben Allen
  • Start date Start date
B

Ben Allen

Hi,
I have set up an image which when clicked on runs a macro which opens a
form. This form has 2 buttons, 'To Ship' and 'To HQ', these are there as the
document is designed to be sent to a cruise ship, updated and then sent back
to HQ. The code of this form is:

Private Sub ToShip_Click()
Unload Me
Application.Dialogs(xlDialogSendMail).Show _
arg1:="(e-mail address removed)", _
arg2:="Emailing To Ship"

End Sub

Private Sub ToHQ_Click()
Unload Me
Application.Dialogs(xlDialogSendMail).Show _
arg1:="(e-mail address removed)", _
arg2:="Emailing To Headquaters"

End Sub

When i run this it works fine, however, after emailing the file excel cuts
back to the desktop (or last open window) and when i click the image to
bring up the form i get 'Error 75', when clicking de-bug 'Email.Show' is
highlighted in yellow. This is the code for the word art/ picture that can
be clicked on:
Sub Picture12_Click()
Email.Show
End Sub
Sub WordArt14_Click()
Email.Show
End Sub

Sorry for the long post and thanks in advance for any replys.
Thanks Again.
--
Cheers,
Ben

Remove your.tonsils to reply
"You only live once but if you do it right once is enough!"
 
Ben

In the VBE, go to Tools - Options - General. In the Error trapping area,
make sure "Break in Class Modules" is selected.

I suspect that there is an error in your userform module. Making this
setting change will show you the line that's causing the problem (it's not
Show, it's something else in the userform's class module).

If the problem isn't obvious when you see which line it is, post back.
 
Dick said:
Ben

In the VBE, go to Tools - Options - General. In the Error trapping
area, make sure "Break in Class Modules" is selected.

I suspect that there is an error in your userform module. Making this
setting change will show you the line that's causing the problem
(it's not Show, it's something else in the userform's class module).

If the problem isn't obvious when you see which line it is, post back.
Click to expand...
Cheers,
It seems it was an error specific to Excel 2000 ( i need to install SP2).
See 'Sending Workbook by Email' (First message sent 13/03/2004 19:19),
theres a link there to a microsoft page about the exact error i recieved.
Thanks anyway,
--
Cheers,
Ben

Remove your.tonsils to reply
"You only live once but if you do it right once is enough!"
 
Back
Top