How to email data from a form?

[Guest]

MS Access 2000, Windows XP
======================
Hi,

I have a form to enter new record, and what I'd like to accomplish is that
when the user clicks on the button "Sumbit Request" on the form after filling
out the fields, the following actions happen:

1. The record is saved.

2. A simple report is generated with the information filled out (not
necessary to display the report to the user, though it'll be nice).

3. The report (in snapshot format) is automatically emailed to two
pre-determined/hard-coded email addresses (these could be stored in a table
to make modifications easier).

I have some idea on how to email the report using SendObject (I'll look it
up right after I send this), but I'm not sure how to achieve all these 3
actions with a single click of a button.

Also, how and where would I specify the format of the report (snapshot) to
be emailed? I want this to be handled "behind-the-scenes" using code instead
of the user specifying this.

Thanks for any help/pointers.

-Amit

 

[Chris Reveille]

In your macro
Action1 Run Command
Command Save record

Action2 Send object
ObjectType Report
Object name Your report name
Object format snapshot
to email addresses seperated by ;
The rest you know

Add abutton on your form that runs this macro.

Chris

 

[Guest]

Thanks Chris. Your post was quite helpful. I made it work.

-Amit