email single record with sendobject

[Brian K. Sheperd]

I want to be able to email a report which contains information about a
single item in the database (i.e., debit memo with a specific RMA number as
the primary key). If I try to the following:
docmd.sendobject acsendreport, "DebitMemo", acformatrtf, "(e-mail address removed)",
, , "test", "test", False
I get multiple records in the attachment.

Thanks,
Brian

 

[Pat Salmon]

Hi Brian,
Were you able to solve your problem? I am trying to do a similar
thing. It will work if I preview the report first. If I send the
report directly to the printer the email contains a report with all
records in the table.

Hopefully you will be able to help me

Thanks,
Pat