Sending a Report to Someone through e-mail

C

ChuckW

Hi,

I have a sales manager that logs into an Access database every morning and
runs a report. I would like it make it so that our system will e-mail him
this report at a certain time of day. The database resides on a fileserv
which has Access and outlook on it. There is an outlook account set up as
well. I don't know if sending something through outlook is the best way of
doing this but I would like a way for the system to somehow send him the
report in batch mode.

Thanks,
 
R

Ron Weiner

If it were me I would Create a single purpose Access program whose only job
was to run a report that it would save as a temporary Snapshot or PDF file
(as Appropriate) and Email that file to the single recipient or group using
Generic code to Send an Email with an attachment that can be found here.
http://www.worksrite.com/CDOMail.htm. When it is done sending the Email it
would delete the temp Snapshot or PDF and Quit.

You can Schedule the job to run at a predetermined time of your choice using
the NT, Win2K, or Win2K3 Scheduled Tasks service. I have successfully used
this kind of automated updating and reporting many times with great
reliability. I would NOT attempt to automate Outlook as recent Outlook
security enhancements make this kind of unattended Email sending somewhat
problematic. Using CDO to send mail IMO is a better way to go.
 
Top