How to email the current record on a form (2)

  • Thread starter Thread starter Dummy
  • Start date Start date
D

Dummy

Allen:

Thank you so much for your prompt and very detailed response.

I followed your instructions but when I clicked the command button, I got
the Run-time error 2498: "An expression you entered is the wrong data type
for one of the arguments." When I clicked the Debug button, the following
lines in the VB window were highlighted in yellow:

DoCmd.SendObject acSendReport, "Report1",, Me.Email,,, _
"Here tis", "Find your report attached", True

The name of the report is correctly Report1 (in Step 2 of your instructions
I saved the report as Report1). The only thing that I changed in the
procedure is the first line:

Private Sub Command12_Click()

instead of:

Private Sub cmdSend_Click()

because Command 12 is the name that was generated when I inserted the button
in the form.

What could be wrong?

Thanks again for your input.
 
Back
Top