get functions in a submit button.

Hello briant97,

Here is the macro for the "Submit" button. Add a VBA module to your workbook project. Copy and paste this code into it. Follow the directions below on how to attach the macro to the button.

'Submit Button macro
Sub SaveAndSend()
  Save_File
  SendMail1
End Sub

Add the Macro to the Command Button
1. Right Click the Button.
2. Click View Code... from the menu.
3. A new window will open titled Assign Macro.
4.Click the entry SaveAndSend in the list.
5. Click OK.
6. Use CTRL+S to save the changes.