Hi,

Currently i have a application which has a "generate excel" button. Once user clicks on it, asp will export the data to excel format. Users can then save the excel format and submit as report.

However, due to demands, they want the excel format to be auto-generated and sent via email to them. Is it possible to do so? if it is, what is the way?

In addition, what is the code to read in data from access database and put it in excel format using vbs?

Thanx in advance.