Nov 22, 2001 #1 Lee24 Programmer Apr 11, 2001 103 GB I am trying to let the user enter information into a form and have a button that allows them to email it to someone! Is this possible! Thanks In Advance!
I am trying to let the user enter information into a form and have a button that allows them to email it to someone! Is this possible! Thanks In Advance!
Nov 30, 2001 #2 rss01 Technical User Oct 10, 2001 125 US Use this Private Sub Command2_Click() DoCmd.SendObject acSendForm, "form2", acFormatXLS, name2, , , "My Subject text", , False End Sub "form2" = Name of your form acFormatXLS = the format your sending the form as name2 = the email address Hope this helps. Randy Street Upvote 0 Downvote
Use this Private Sub Command2_Click() DoCmd.SendObject acSendForm, "form2", acFormatXLS, name2, , , "My Subject text", , False End Sub "form2" = Name of your form acFormatXLS = the format your sending the form as name2 = the email address Hope this helps. Randy Street