sending workbook in email

[juster21]

I created a form for my coworkers to use to submit requests. I have everything complete (all combo boxes work, a reset button...yada yada) but I wanted to have the Workbook_Open call the Reset_Click event and also by using a Submit button, have the form emailed from the user to me. Any ideas?

 

[Smitty]

If you use Outlook, see www.rondebruin.nl/sendmail.htm

Or the SendMail Method:

SendMail Method Example

This example sends the active workbook to a single recipient.

ActiveWorkbook.SendMail recipients:="Jean Selva"

HTH,

Smitty

 

[juster21]

Thanks Smitty. Any ideas on calling the Reset_Click event in the Workbook_Open event???

 

[Smitty]

Any ideas on calling the Reset_Click event in the Workbook_Open event???

When I have to do that I generally put the button code in a general module and call it in both places.I.E.

Private Sub Workbook_Open()
  Application.Run "Reset_Code"
End Sub

Private Sub Reset_Click()
  Application.Run "Reset_Code"
End Sub

Smitty