emailing reports

[ofelia welch]

I have created a macro that emails a report. I would like
for the macro to run automatically when a new record is
completed.

Where would I put the macro that emails the report as soon
as the record is created? Do I do it the report? Any
ideas?

Thank you!

 

[Larry]

-----Original Message-----
I have created a macro that emails a report. I would like
for the macro to run automatically when a new record is
completed.

Where would I put the macro that emails the report as soon
as the record is created? Do I do it the report? Any
ideas?

Thank you!
.
If you are creating the records in a form then run the

macro from the last entry field on the exit event

 

[Van T. Dinh]

Use the Form_AfterInsert Event.