sending report with one push on a button

[Jean-Paul]

Hi,
I have a continuous form containing records after running a query..
Now I want to create a pushbutton that, when pushing, automatically
sends a report, based upon this recordset, to my boss.

Creating the report itself is no problem, but how to send it?

Should it be as an attachment, can I put everything in the mail-body?

Any help is welcome
Thanks

 

[Jean-Paul]

this is what I wrote:

DoCmd.SendObject acSendForm, "weekplanning", ,
"(e-mail address removed)", , , "testje", "voor de wim", , True

In the help file I can't find much about the acSendForm command...
Do I have to create a report first (based upon the query I use for the
continuous form)
Is my syntax correct or not... any suggestions

Thanks

 

[Jean-Paul]

I managed to send a report but:
Before sending I am asked how to send the report: snp, html, rich text...
How to avoid theis question and always use snp?

The messages are stored in the mailbox out folder of outlook... so the
reports are send upon opening outlook...
Is there a wasy to immediatly send the report without having to open
outlook first?

Thanks