How to send report in an email via button

[PaveFE]

Hi all,

I have a database that where I want to have a clickable button (macro?) where upon clicking, it will send an email of a report (or a snapshot view of the report) that is created from the information they just filled out in a form. Is that possible?
Also, can I have a button that will just print out the report vs. the form. I don't want it to open the report, just print it.

Thanks,

VD

 

[Remou]

Have you looked at DoCmd.SendObject and DoCmd.OpenReport?

 

[Remou]

PS This is the Jet SQL forum, it would be better to use the Forms forum for this post. You might like to look at
Which Access forum should I choose for my question? Why?
faq181-1655

 

[PaveFE]

Thanks