in you local system .xlsx file able load 1,000,000 rows. but in your server .xls able to load only 65k rows. how many number of rows is there in your...

In your source may be it have more than 65,000 rows, if it is yes divide total number of rows in to different sheets.

Thank you, by the end of day i got result with data driven subscription.

yes, i am using enterprise only, can give me query to get particular person data, main problem with sending email to particular person, can you provide detail query to send...

Thank you i will try these ways...

kishore.

hi gila, thanks for reply, i didn't get the below result by using your code or i didn't use properly. can you give some more details to use because i...