AUTOMATICALLY RUNNING ACCESS PROGRAM AND SENDING OUTPUT IN EMAIL

[Scott RN]

set up macro to run query automatically, convert to excel spreadsheet and
then automatically email data to email address; I am using Access 97; I can
get the macro to run it to the excel spreadsheet, but cannot find a way to
automatically email the data

 

[Ron Hinds]

Check out the tips on Tony's web page for eMailing from Access:

http://www.granite.ab.ca/access/email/index.htm