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.
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.