email single record with sendobject

  • Thread starter Thread starter Brian K. Sheperd
  • Start date Start date
B

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
 
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
 
Back
Top