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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DoCmd.Send Object ---PDF File ? 1
Need ID going into Database 2
email multiple reports from one report 10
HasData Property 2
Question about... 2
Email a Report, Please 8
Apply filter for Printing 1
Can't create a report from my query in Access 1

Back
Top