how do I automate reports

teddarr

My company maintains an access database. We use this database to generate a report 3 times a day and email it to a distribution list. How do I go about using the system clock to automate the report update and is it possible to have that emailed using outlook without having to open the database and manually do everything?

Tanis

You can either use code in an On Timer event of an unbound form, or you could use the Widows Scheduler. For the second part of your question, have a look here.

http://www.jephens.com/howtoemail.asp

teddarr

Much Thanks, You will soon have made many people a little happier!!

how do I automate reports

re: how do I automate reports

re: how do I automate reports

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about