send object (current record)

[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

 

[Perry]

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