Can I insert a button with a command specified to send an e-mail to several recipients containing the contents of a few fields entered in the form?![]()
Can I insert a button with a command specified to send an e-mail to several recipients containing the contents of a few fields entered in the form?![]()
The simplest method would be to use SendObject. Check that out in VBA help and see how it goes.
That sounds like it would almost do exactly what I'm looking for.Is there any way to send only two specific fields from a table? Or would I just have to make those two fields their own table and send it that way? Would I then be able to only send one record from the table as well, instead of the whole thing? Thanks.
There are a lot of options. You mentioned data entered on a form, so you could simply add data from the form into the body of the email. This would be building a string variable that would then be used with SendObject:
strBody = "Dear " & Me.FirstName & vbCrLf & "Thanks for buying a " & Me.ProductName