Data extraction from record type to excel and generate report and email

Hi all,

    I want to extract all the data of table (multiple table) and export to excel and generate report and then email. we don't have CDT we use record type. please help me how to extract data from record type or database and export to excel, generate report & email.

What i have tried:  I used Export SQL to Excel plug in with sql query and Jndi name which is my data source but it is throwing me error as "The following error was raised by the Export to Excel function:  null".

Please help me to resolve this issue or if there is any other way let me know.

Thanks