Hi
The problem is not sending the report to the email server - not oo
difficult. Create a macro to run the e mails, then use a scheduled task on
windows (I have used a call shell for this in the past) to run the macro at
whatever time - in case it goes wrong you can also use the macro to store the
date/time into a new table and then (1st line of the macro) check the
date/time is not in the last 12 hours (for example) to stop the same report
being sent twice.
The problem is if you are using outlook (or O-express) with the secutrity
warnings (which, if you think about it, is a good thing). You will need to
bypass O or O-express and send directly to the e mail server which you can
only do with difficulties. Ask about this in the Outlook forum 1st (on the
left of your sreen). As there may be a method to by pass the security warning.
Good luck
