Thread: Submit to Email Command Button
View Single Post
 
Old 08-20-2015, 05:05 AM
rob7676 rob7676 is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Aug 2015
Posts: 1
rob7676 is on a distinguished road
Default Submit to Email Command Button
I have created a simple suggestion form with a basic command button. However when I click submit, it opens two email windows rather than 1.

Code:
Private Sub CommandButton1_Click()
    Options.SendMailAttach = True
    ActiveDocument.SendMail
End Sub
Also, is there a way I can make the button hidden after submit is clicked so it doesn't send through with the attachment?

Thanks
Reply With Quote