09-24-2009, 01:40 PM
For scheduling the batch you can use windows schedular.
For sending the xls, you will have to use Outlook object or CDO.
PS: always try to search the forum first before making your query, there are tons of information here, which has been discussed in threads and articles.
For sending the xls, you will have to use Outlook object or CDO.
PS: always try to search the forum first before making your query, there are tons of information here, which has been discussed in threads and articles.