I used the command button wizard to create the button. Then, I selected
"report operations" and then selected "mail report"
I'm not sure if this helps....
:
Bill wrote:
Sorry for upsetting you...let me explain a little further...
I created a command button in a switchboard form. You click on the
button and it generates the report and attaches it to a blank e-mail.
But by what mechanism is it generating an Email? Is it using the SendObject
command? If so, then that has arguments for the To, the CC, the BCC, the
Subject, etc.. All you have to do is supply those values.
If you are using something besides SendObject to generate the Email then we
need to know what that method is in order to supply any information.
No it doesn't help.
You need to open your form in Design View. Select the command button.
Display it's property sheet. Click on the property sheet Event tab.
On the line that says On Click it will say [Event Procedure].
Click on the little button with the 3 dots that appears on that line.
When the code window opens, the cursor will be flashing within a Sub
Procedure. It will begin something like
Private Sub CommandButtonName_ClickI()
It will end, several lines down with
End Sub
Highlight and copy that entire procedure.
Paste it into a reply message and post it in this same thread.
** Also tell us how Access is going to know what the e-mail address
is. Is it stored someplace in a table? What is the actual name of the
field? ** Remember, you can see your database ... we cannot.
And I'm not upset. It's just not possible for us to know how to advise
you without getting the necessary information.