Emailing report

[ofelia welch]

I have a created a macro that emails a report. The data
is entered into a table via the Web from our web site.
When the user presses the submit button on the web the
data is dumped into the database table. The record is not
created using a form. I need to email the new record
report as soon as the record is created. Where do I put
the macro so that it can run the report?? Any ideas??

Thanks!

 

[Larry Williams]

Good Afternoon:
What I have done is to create a query and then use
the "sendto" function as a step in a macro. This is easy
because you can dictate what form [xls, doc, txt] the
information goes out in.

How ever you may run into the same problem that I have run
into. Outlook 2002 doesn't like to allow to have email
generated from other programs. Understandably so with all
the hacks out there. I have posed the question of how to
selectively turn this security feature off. I'll let you
know what I find out.

Best Regards,
Larry