Hello All!

I am trying to to create an auto emailing function from microsoft access from a report I created. It would be sent out every week ending date, to numerous people.

Would anyone here be able to give some points or instructions in doing so?

Thanks in advance.

-Nick

You wouldn't do this from within the report. You would create a procedure that runs when the database is opened (you could put it in the switchboard form) and determines if the report needs to be run. If it does, the procedure would run the report and email it. Otherwise, the database would open normally.

If I were going to do this, I would create a table to keep track of the last time the report ran. This allows for flexibility should you need to rerun the report. You would just change the last run date and reopen the form.