Send a record from a form as an email

  • Thread starter Thread starter S.Matthew
  • Start date Start date
S

S.Matthew

When you click a command button on a form is it possible
to send only that record as an email. If so how?

Thanks in advance
S. Matthew
 
S. Matrthew,

Yes. I suppose the most straightforward approach is to make a Query,
which used the key field in the form's data in the Criteria of the
query, using syntax such as [Forms]![YourForm]![YourKeyField]
.... and then use code based on the SendObject method to make your email,
and export the query, or a report based on the query. Hope that makes
sense.
 
Back
Top