Hello briant97,
Assuming all the code you post resides in a VBA module in your project, add the calls to the click event for the submit button. It would help top know what type of button you are using: Forms or Control Toolbox.
For Example
![]()
Private Sub CommandButton1_Click() SaveName SendEmail End Sub
Bookmarks