Automate generation and distribution of forms

[audrey.nsh]

Hi,

I have an Access 97 database where the users loads the data (from
multiple sources) and generates forms at a click of the button and
the user saves the form as .xls and
distributes to other users via e-mail.


I need to automate the process of generating the forms, saving the
report and distributing to other users via e-mail


Can someone guide me in the right direction?


Thanks,


Audrey

 

[Douglas J. Steele]

Sorry, but that doesn't make sense.

It's very unusual to generate forms dynamically, and I can't think of how
you'd save a form as a spreadsheet!

Are you sure you don't mean that a query is generated and saved?