I was creating a spreadsheet (forms) to collect feedback and I put a button on called "submit" to get people submit the data...
The code is as follows:
Sub Button1_Click()
MsgBox "Survey Completed. Thanks a lot!"
ActiveWorkbook.Save
Application.Dialogs(xlDialogSendMail).Show
End Sub
In this way I can get the email program open automatically when people click the button.
But Can I actually modify the code somehow and get my email address filled and send the email out automatically?
Thanks, P
Bookmarks