DoCmd.Send Obkect Help

  • Thread starter Thread starter bgreer5050
  • Start date Start date
B

bgreer5050

I have a report "OpenPosReport" that uses a query "OpenPos":

I would like to send the report to a recipient from a field
"RequestorEmail" using Do.CmdSendObject.

I have sent reports using Access Macros before, but never using the
DoCmdSendObject.

Can someone please help me write the code?

Thanks
 
Say it was on the DoubleClick event of the RequestorEmail control:

Private Sub RequestorEmail_DblClick(Cancel As Integer)

DoCmd.SendObject acSendReport, "OpenPosReport", acFormatRTF, _
Me.[RequestorEmail], , , _
"Here is the OpenPosReport that you requested", , False

End Sub
 
Back
Top