send object (current record)

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have this code, but it sends the entire table. I want
the email to contain just the information for the record
displayed on the form. I assume I would obtain the
record number, pass it to a query and email the query.
But I'm not sure, any suggestions?

Private Sub Command10_Click()

DoCmd.SendObject acSendForm, "Example", acFormatRTF, _
"(e-mail address removed); (e-mail address removed)", , ,
_
"Form", , False


End Sub
 
Why not use a dummy report for this particular record?
You can also fancy format the report and then use the
SendObject() to mail the report.

Krgrds,
Perry
 
Back
Top