• Lempster,

    Thank you for your help. Now I have another question regarding to my project. basically I need to generate a report and export it to the spreadsheet and then send an email with the attachment to some people daily. I was asked to put the date (yyyy-mm-dd) into the xls filename. Do you have any idea how to do that (build a dynamic filename)?

    Thanks,

    BCC

    --------------------------------------------------------------
    DBA or SQL Programmer? Who Knows. :unsure: